3 Replies Latest reply: Jun 10, 2016 6:51 AM by Sunny Talwar RSS

    Use calculated value into new calculation

    Jurien Groot

      To create a forecasted revenue I have the following calculation.

       

      num(SUM({1<MonthNum ={"<=$(=Num(Month(Today())))"}, Year={"$(=Year(Today()))"}>}[Revenue])

      / SUM({1<MonthNum ={"<=$(=Num(Month(Today())))"}, Year={"$(=Year(Today())-1)"}>}[Revenue])-1,'#,##0.0%')

       

      This gives a ratio of this year YTD revenue vs last year YTD revenue. Now I want to use that ratio into a calculation about 2016.

       

      Say [actual revenue] *

      num(SUM({1<MonthNum ={"<=$(=Num(Month(Today())))"}, Year={"$(=Year(Today()))"}>}[Revenue])

      / SUM({1<MonthNum ={"<=$(=Num(Month(Today())))"}, Year={"$(=Year(Today())-1)"}>}[Revenue])-1,'#,##0.0%')

       

      However, if I plot this in a table with a year dimension I get nothing.