Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community
I need some assistance with the below:
(SUM({<CurrentPer={1}>}[MAT VALUE]) -SUM({<PriorPer={1}>}[MAT VALUE]))
This part of the syntax works perfectly. I now want to express the above as a % of the respective Total Month
If I use the function Total as below I get the wrong output:
(SUM({<CurrentPer={1}>}[MAT VALUE]) -SUM({<PriorPer={1}>}[MAT VALUE]))/
(SUM(total{<CurrentPer={1}>}[MAT VALUE]) -SUM(total{<PriorPer={1}>}[MAT VALUE]))
Can you help please
Regards
this
(SUM(total{<CurrentPer={1}>}[MAT VALUE]) -SUM(total{<PriorPer={1}>}[MAT VALUE]))
would give you the total (also the total for all months)
so edit to
(SUM({<CurrentPer={1}>} total <yourMonthfield> [MAT VALUE]) -SUM({<PriorPer={1}>} total <yourMonthfield> [MAT VALUE]))
Regards
this
(SUM(total{<CurrentPer={1}>}[MAT VALUE]) -SUM(total{<PriorPer={1}>}[MAT VALUE]))
would give you the total (also the total for all months)
so edit to
(SUM({<CurrentPer={1}>} total <yourMonthfield> [MAT VALUE]) -SUM({<PriorPer={1}>} total <yourMonthfield> [MAT VALUE]))
Regards
Thanks. Perfect