Forum Discussion

Lexey's avatar
Lexey
Helper I
8 years ago

Percentage between two values

Please help in solving one problem. You need to calculate the percentage as the ratio of [delta plan] and [plan]. Tried different options but have not yet found solutions.
Need Help
Lexey's avatar
Lexey
Helper I
8 years ago

Thanks
I didn't get quite the right result

 

delta % plan = sumx('fact'; [delta plan]/ [Values of budget])

 

Floriankx's avatar
Floriankx
Solution Sage
8 years ago

What would be your expected results?

 

For the total row I see it makes no sense.

You may have to change to delta % plan = sum([delta plan]/sum[Values of budget]