10 Replies Latest reply: Mar 13, 2018 1:30 AM by Jonathan Dienst

# Table: Show only SUM greater zero

Dear all,

I have created a table with all different dimensions + one measurement which is the sum of AR = sum([AR AMT USD]).

But when creating the tables the tables show also values where the amount is 0. I only want to show the AR amount which is anything greater than 0 USD.

Thanks

Ugur

• ###### Re: Table: Show only SUM greater zero

Try like this - only({<AR Amount ={">{0}"}>}sales).

• ###### Re: Table: Show only SUM greater zero

Is there inside { } required???

Try below

Sum({<AR Amount ={">0"}>}sales).

Regards,

• ###### Re: Table: Show only SUM greater zero

Thank you

• ###### Re: Table: Show only SUM greater zero

You can delete records at script side by using "where"

..

..

Where [AR AMT USD]>0;

• ###### Re: Table: Show only SUM greater zero

if(sum([AR AMT USD])>0,sum([AR AMT USD]),'')

• ###### Re: Table: Show only SUM greater zero

Thank you very much for all of your answer, but unfortunately non of these worked , what I need is the following:

Now the table looks like this:

 User Name Sum([AR Amt USD]) Derk Boss 321 Agnes Injury - Robbie Williams - Albert Einstein 492 Alexander the Great 117 George Clooney 190

And needs to be like this:

 User Name Sum([AR Amt USD]) Derk Boss 321 Albert Einstein 492 Alexander the Great 117 George Clooney 190

So eleminate Agnes Injury and Robbie William.

Thanks

Ugur

• ###### Re: Table: Show only SUM greater zero

go to chart property > add ons > Data handling > untick include zero values

Regards,

• ###### Re: Table: Show only SUM greater zero

This doesn't work with more dimension or more measurements.

• ###### Re: Table: Show only SUM greater zero

When suppressing zeroes and nulls, the dimensions don't matter, but you will need to edit the other expressions (measurements)

=If(Sum([AR Amt USD]) > 0, <your expression>, 0)

• ###### Re: Table: Show only SUM greater zero

I'd suggest you something like this:

Cheers