1 Reply Latest reply on May 11, 2018 8:06 AM by Simon Runc

    Using an Aggregate function (SUM) in a IF statement

    Aileen Rotondo

      Hello,

       

      I am trying to get the sum of some numbers within an if statement. However I'm getting the error "Cannot mix aggregate and non-aggregate comparisons or results in 'IF' expression.

       

      Things to note: Month is in number format.