2 Replies Latest reply on Nov 19, 2013 7:43 AM by Valerie Williams

    Counting values inside a data field with exclusions

    Valerie Williams

      I am trying to create a calculating field that counts all values in a field with one exception. I already have a calculating field to count a single value, but now I want the opposite. Here is the formula to count the single value: case [TypeofChange]when "Urgent" then [Total Tasks]End. The "Type of Change" field contains a number of values including "Urgent". Now, I want all of the other values to be counted with the exception of Urgent. How should I write this formula? I am sure there is a simple expression but I am at a loss. Thank you.