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

    Using an Aggregate function (SUM) in a IF statement




      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.