Hello,
I have a problem with calculating the percentages between two values: Sum(X)/Sum(Y)*100.
Current calculation Z= :
sum({<Cal_RollingREM.CalendarRollingIdentical = {1},I.ItemName = {'Rent'}>}X)
/
sum({<Cal_RollingREM.CalendarRollingIdentical = {1}>}Y)
*100
As you can see I'm getting wrong Total and arithmetically good column values, but I need different result. I need total to be 100% and column values to reflect part of Total value. In example:
I have tried different calculations. With Sum(Aggr(...)) I got wrong values, but with the Total(Z) I got correct Total values but wrong column values:
Total(Z) calculation:
(sum({<Cal_RollingREM.CalendarRollingIdentical = {1},I.ItemName = {'Rent'}>}X) / sum({<Cal_RollingREM.CalendarRollingIdentical = {1}>}Y)*100)
/
(sum({<Cal_RollingREM.CalendarRollingIdentical = {1},I.ItemName = {'Rent'}>}Total X) / sum({<Cal_RollingREM.CalendarRollingIdentical = {1}>}Total Y)*100)
Object ID is not unique value, it can hold different X and Y values:
Thank you in advance 🙂
