Calculate an increase/decrease %

[andreab]

Hi

I should create the increase / decrease % compared to the previous month
at the moment i calculated the difference via the calculated field

difference(
sum( xxx ),
[{conversion_date} ASC],
-1)

and this graph appears

at this point I know that November has this figure: 6022
while December: 6000
so there is rightly a decrease of -22 as per the graph

now though I would have to divide the -22 by 6.022

(-22/6022)%

How do I set it to automatic for all months? what calculated field should i create/use

thanks
Andrea

[MKuhns01]

You can use periodOverPeriodPercentDifference.

Like so:

periodOverPeriodPercentDifference(sum({xxx}), {Date}, MONTH, 1)

[Kellie_Burton]

Hi @andreab-
Did the periodoverPeriodPercentDifference function get you the expected results? If not, please provide additional details.

Thanks,
Kellie