Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi QV Experts,
I am trying to create a straight table with 2 calculated expressions. The calculated expressions are actual missing qty and actual missing value for each of the customer at a part number level.
If you see, at a part number level the calculation works just fine. However, if you look at the sub-totals, they dont seem to work correctly.
Can someone help?
Attached is my qv sample.
Thanks,
Ram
Looks like first one working as expected? For second one either you can use
OR, direct expression without any setting changes?
=Sum(Aggr((sum([Missing Quantity])-sum([Ordered Quantity]))*([ESC LAV]), Customer, [Part Number]))
Looks like first one working as expected? For second one either you can use
OR, direct expression without any setting changes?
=Sum(Aggr((sum([Missing Quantity])-sum([Ordered Quantity]))*([ESC LAV]), Customer, [Part Number]))
Try adding Sum(Aggr()) or use Sum of rows for Total mode
Hi Sunny,
Appreciate it. It was a quick fix.
Howerver, i have this in a PIE chart and this option is not enabled. Any work around?
Thanks,
Ram
Use Sum(Aggr())
=Sum(Aggr((sum([Missing Quantity])-sum([Ordered Quantity]))*([ESC LAV]), Customer, [Part Number]))
Thank You Sunny. Appreciate your help
no problem