Percentage calculation

MK97 — Mon, 19 Sep 2022 16:19:42 GMT

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 🙂

topic Percentage calculation in QlikView

Percentage calculation