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!