4 Replies Latest reply: Jun 13, 2018 5:30 PM by David Forest RSS

    percent change

    Nick Barker

      Hello,

       

      I am looking to create a line graph that shows percent change only of the sum of sales from month to month. The line graph will also have multiple business units on the graph

       

      I have tried a few options and none have helped thus far. Any recommendations would be great!

       

      These are a few options I have tried...

       

      Num(((sum(sales)) - sum(addmonths(RT_Date,-1)(sales)))

      / sum(addmonths(RT_Date,-1)(sales)))

       

      Num(Sum(sales)/Above(Sum(sales))-1)