6 Replies Latest reply on Apr 29, 2015 10:53 AM by HAimanti Banerjee

    How can I resolve the error that I am getting when  creating this calculated field.

    HAimanti Banerjee

      IF [Rolling Previous 3 Month] THEN Sum([Measure Value]) ELSE NULL END.

      Where [Rolling Previous 3 Month] is a boolean. Error message I am getting that cannot mix aggregate and non aggregate in IF statement.

       

      I will have to create two colms in the report one for the baseline, [Rolling Previous 3 Month]

      and another one is Rolling Current 3 Months.

       

      Any help will be appreciated.

      I tried to wrap it up with ATTR, did not work either.

       

      Thanks,

      Haimanti