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

    percent change

    Nick Barker



      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)))