Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Have you tried total mode to be expression total in expressions tab?
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?
i can't do that with pivot table.
Did you try like this?
Sum(Aggr(If(Sum(A) <> 0 , Sum(B)), Prd_Desc_Group, Prd_Mat_Group_Ext))