9 Replies Latest reply on Apr 15, 2016 11:08 AM by Harnish Patel

    Aggregation issue with IF/CASE statement

    Harnish Patel

      All,

       

      I am having trouble creating a calculated field, where my the values will not aggregate when the differentiator is removed.

       

      Example:

      CASE attr([Month]

      WHEN "Jan" THEN ([Total]*(1.035))/[Den]

      WHEN "Feb" THEN ([Total]*(1.0375))/[Den]

      END

       

      When I add the [Month] pill in the rows, the values are correct, but when i remove the month pill, the result is blank. I've tried wrapping them in sum functions/Total functions/etc.

       

      Any ideas what may be happening here?

       

      Thank you.

       

      I am trying to create a sample workbook to share, but i'm not even sure which level of fidelity is causing this. Does anyone know how to anonymize entities and accounts?

       

      Thank you all!