5 Replies Latest reply on Feb 17, 2016 4:35 AM by Simon Runc

    Calculate new measure as a percentage of another

    John Bartlett

      I have two measures, call them [Joiners] and [Leavers] I want to show [Leavers] as a percentage of [Joiners], so [Leavers]/[Joiners].  Fair enough.

       

      But my data is stored by date and I'm displaying by month.

       

      So the percentage calculation gets delegated to the database and then summed, which is obviously wrong.

       

      How do I calculate the percentage in context and not delegated to the database row?