Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me on below requirement.
I have Two KPIs Current Month Amount and Previous Month Amount
[CM Amount] =Count({<[Month Year]={$(=Max([Month Year]))}>}Sales) Result : 32.68
[PM Amount] =Count({<[Month Year]={$(=Max([Month Year])-1)}>}Sales) Result : 27.31
Please help me to write the expression for how much Amount Percentage increased in Current Month compared to Previous Month.
Thanks in advance
you can try this
(
Count({<[Month Year]={$(=Max([Month Year]))}>}Sales)
/
Count({<[Month Year]={$(=Max([Month Year])-1)}>}Sales)
)
-1
the increase would be 20%
so you can get the percentage increase
you can try this
(
Count({<[Month Year]={$(=Max([Month Year]))}>}Sales)
/
Count({<[Month Year]={$(=Max([Month Year])-1)}>}Sales)
)
-1
the increase would be 20%
so you can get the percentage increase