The column is missing totals

[Janaszek]

HI, i have problem. i use : if(Aggr(SUM(Document_PZ),Document_ZZ)=0,Sum([Document_ZZ]))
The column is missing totals. What can I do?

Sum(if(Aggr(SUM(Document_PZ),Document_ZZ)=0,Sum([Document_ZZ])) <---NOT WORK

[Vegar]

Your if statement is probably false for the total row.

SUM(Document_PZ),Document_ZZ)<>0 

and therfore you gett null().

Try: sum(aggr( if(  SUM(Document_PZ)=0, Sum([Document_ZZ])),Document_ZZ))

I short, you need to create an expression that is valid for the expression without any dimension restrictions

[sunsun566]

Hi 

Or the other two methods for your reference. Hope it will help you:)

1. Edit Total by yourself.  Generally Total is placed in RowNo() = 0 or null. 

If it is a Pivot Table, it is ColumnNo() = 0 or null

  ex>  IF( RowNo() = 0 or Isnull(RowNo()), .....)

2. Use between two conditions "+"

 ex> 

if(Aggr(SUM(Document_PZ),Document_ZZ)=0,Sum([Document_ZZ]))  + if(Aggr(SUM(Document_PZ),Document_ZZ) <> 0, 0)

[Janaszek]

I gave the wrong data, they are correct:

if(Aggr(SUM(Quantity_Document_PZ),Document_ZZ)=0,Sum([Quantity_Document_ZZ]))

[Janaszek]

the ideas given above don't work.
maybe it's a quantity syntax problem?

[Janaszek]

have any ideas?

[Anil_Babu_Samineni]

You should include all dimensions which plot like

Sum(Aggr(if(Aggr(SUM(Document_PZ),Document_ZZ)=0,Sum([Document_ZZ])), Dimension1, Dimension2, etc.))

[Lech_Miszkiewicz]

If you wish to stick to If & Aggr I suggest following:

Sum( if(Aggr(nodistinct SUM(Quantity_Document_PZ),Document_ZZ)=0,[Quantity_Document_ZZ]))

or much better option which will be a lot better performing and not using Sum(If(Aggr: which gives me a satisfaction...

Sum({<Document_PZ={"=Sum(Quantity_Document_PZ)=0"}>}[Quantity_Document_ZZ]) 

hope this helps!

[Janaszek]

Thanks Lech

Sum({<Document_PZ={"=Sum(Quantity_Document_PZ)=0"}>}[Quantity_Document_ZZ]) 

this works!!!