Issue with chart

[ramanarayan]

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

[Anil_Babu_Samineni · Accepted solution]

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]))

[sunny_talwar]

Try adding Sum(Aggr()) or use Sum of rows for Total mode

[ramanarayan]

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

[sunny_talwar]

Use Sum(Aggr())

=Sum(Aggr((sum([Missing Quantity])-sum([Ordered Quantity]))*([ESC LAV]), Customer, [Part Number]))

[ramanarayan]

Thank You Sunny. Appreciate your help

[sunny_talwar]

no problem