topic Re: percent change in App Development

percent change

nhbarker — Tue, 12 Jun 2018 13:01:43 GMT

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)

Re: percent change

Chanty4u — Tue, 12 Jun 2018 16:11:31 GMT

try this

Num(Sum({<Year = {'$(=Max(Year))'}>} Sales)/Sum({<Year = {'$(=Max(Year) - 1)'}>} Sales) - 1, '0%'), Num(Sum(Sales), '#,##0.0'))

Re: percent change

sunny_talwar — Tue, 12 Jun 2018 16:26:16 GMT

Try this

Aggr(Sum(sales)/Above(Sum(sales))-1, [Business Unit], (MonthYear, (NUMERIC)))

Re: percent change

nhbarker — Tue, 12 Jun 2018 17:58:01 GMT

Thanks for the responses! Unfortunately these haven't been successfully for me yet, however it is given me a lot more options to try.

Re: percent change

dwforest — Wed, 13 Jun 2018 21:30:45 GMT

With a master calendar hooked to RT_Date.

((sum(sales) - sum({$<Month={"=$(=addmonths(MonthStart(RT_Date),-1))"}>} sales))

/sum({$<Month={"=$(=addmonths(MonthStart(RT_Date),-1))"}>} sales)