3 Replies Latest reply on Jun 16, 2017 10:51 PM by Nagasubramanian S

    IF Statement to Filter

    Tyler Pickering

      I am looking to use an IF statement to basically filter my results and I can't use a filter because some will need the filtering on my table, some will not.


      I have a field called "Status" that will be either OPEN or CLOSED.


      I want my formula to say (in plain English):


      IF status = open, then  (sum field 1) / (sum field 2)


      In other words, I only want it to sum fields that has that OPEN status.


      Any help would be greatly appreciated, thanks!