5 Replies Latest reply on Jun 13, 2012 2:45 AM by Jonathan Drummey

    how to divide two measures to get percentage

    hub.yoo

      Hello,

       

      WHY is it so hard to divide 2 measures to give me a percent?

       

      I have two measures, [goals] and [running total of passing]

       

      goals:

      [Week] * 2175/52

       

      running total of passing:

      IF ATTR([Week]) < ATTR([Nextweek]) THEN

          RUNNING_SUM(SUM([Passing]))

      END

      I have the ATTR([Week]) < ATTR([Nextweek]) so the viz doesnt calculate values for the future.

       

      What I am trying to do is divide the running total of passing with the goal to get a percent to goal.

       

      ANY combination of attr or discrete etc gives me a null value...

       

      any help would be much appreciated.

      Regards,

      Hub