Doubt with if analysis

[#1]

Hello everybody

I'm returning to develop after a long time so i have an easy question

I'm doing this

IF( SUM(A) <> 0 , SUM(B))

This works but in the pivot table when i collapse the '<> 0' doesn't work and the sum isn't correct

Thanks, Greetings.

[sunny_talwar]

The overall Sum is not correct or the line level sum isn't matching? May be you need to add Sum(Aggr()) function in there

[#3]

Have you tried total mode to be expression total in expressions tab? 

[#4]

The sum is OK. The total isn't working

Prd_Desc_Group	Prd_Mat_Group_Ext	Budget	Items	% Var
Total		230920	10.148.433.887	4294.78%
Corn	Total	26500	292478	1003.69%
	1	6000	30699	411.65%
	2	7100	20250	185.21%
	3	7400	3785	-48.85%
	4	6000	26525	342.08%

What do you think i should do?

I tried aggr like with the two dimmensions but i don't see the total. What do you suggest with the aggr?

[#5]

i can't do that with pivot table.

[sunny_talwar]

Did you try like this?

Sum(Aggr(If(Sum(A) <> 0 , Sum(B)), Prd_Desc_Group, Prd_Mat_Group_Ext))