1 Reply Latest reply on Apr 25, 2013 6:36 AM by Brad Llewellyn

    substitute total

    Paul Collier

      Is it possible to substitute a total for another number?

       

      I have a series of data over time.  For the first 2 years i can use the calculation...

       

      SUM([cvps]) / TOTAL(SUM([cvps]))

      and then

      RUNNING_SUM([1 - % of Total])

       

      to work out the cumulative % increase overtime to the total number.

       

      For the third year I have the same data but would want to substitute the TOTAL(SUM([cvps])) with another column from the data that contains a forecast.  I have tried using an if statement to do this but am not having much success.

       

      Should I try bringing in this other data as a separate source and joining it or do something else?

       

       

      Thanks