Skip to Content
Former Member
Oct 29, 2013 at 04:53 AM

Issue in showing result of % value for qty & sales value (Pls read description for details)



Our client is having one of the requirement as per below logic:

There are 3 KPIs for Qty & similarly for values.

1st is CN Qty, 2nd Inv Qty, 3rd is % (calculated KPI).

Now the logic for % = CN qty (individual row value) / subtotal of Inv Qty in one period * 100

and when it come to result or subtotal rows, it should give in the % column: subtotal of CN qty / subtotal of inv qty * 100.

Formula I applied was: CN qty / SUMCT(Inv Qty) * 100

It is giving correct value for each row value except for result rows.

In the result rows, instead of taking the subtotal of inv qty, it rather takes overall result of inv qty and hence the value goes wrong.

May we know from the experts, how to achieve this?

Let me know if you need more details on the same?

Best Regards,

Shyam Alok