1 Reply Latest reply on Aug 9, 2017 3:38 AM by Vishal Jethwa

    Changing a calculation from AGG to SUM

    Matt Kerr

      Hi,

       

      I need to create a calculation like above (so the total earnings of that individual person), the issue I'm having is the above error message. Unfortunately the earnings measure is totaling to an AGG measure, I believe if i change this to a SUM the above calculation would work?

       

      The earnings calculation is as seen above, how do i get this to calculate this into a SUM?

       

      Or if i'm going around this the complete wrong way any help would be appreciated?

       

      Unfortunately i cannot share my workbook as it has sensitive information.

       

      Thanks Matt.