Why No Totals?

[pkelly]

Hi all

I have the following formula in my Pivot Table to calculate Excess Stock Value.

=IF((sum({<pro_FamilyCode = {01, 02}> } inm_OnHandCostQty) - sum({<pro_FamilyCode = {01, 02}> } con_CostQuantity)) > 0,

(sum({<pro_FamilyCode = {01, 02}> } inm_OnHandValue) / sum({<pro_FamilyCode = {01, 02}> } inm_OnHandCostQty)) *

(sum({<pro_FamilyCode = {01, 02}> } inm_OnHandCostQty) - sum({<pro_FamilyCode = {01, 02}> } con_CostQuantity)),

0)

This is calculating our excess stock value on a line by line basis.

I have click "Show Partial Sums" but none are being displayed.

Any ideas?

Regards

Paul

[pkelly]

Apologies if I am causing confusion...

When I tried the test that you suggested, my detail lines are showing positive and negative values and I am receiving totals.

The issue I have is that, when I exclude the negative values, the total's disappear.

Will try your suggestion above.