8 Replies Latest reply on Mar 8, 2016 3:14 PM by Mattia Pradella

    Do Not aggregate

    Mattia Pradella

      Hi All,

       

      I have the below formula giving me the "cannot mix aggregate and non aggregate arguments" on the minus signs. I cannot add a "sum" before the "{include" as it would change all the numbers. I though about having a parameter calculated with a formula but no luck.

       

      Anyone able to help?

       

       

      if countd( [Fortnight end date])*80 - { include[EMPLOYEENUMBER]: sum([STD Hours PAID])}>0 then countd( [Fortnight end date])*80 -
      { include[EMPLOYEENUMBER]: sum([STD Hours PAID])}

      else 0

       

      end