Table: Show only SUM greater zero

[ugurarslan]

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.

Can you please help me?

Thanks

Ugur

[isingh30]

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

[cengizeralp]

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

Load

..

..

Where [AR AMT USD]>0;

[zebhashmi]

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

[PrashantSangle]

Is there inside { } required???

Try below

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

Regards,

[isingh30]

Thank you

[ugurarslan]

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

[PrashantSangle]

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

Regards,

[ugurarslan]

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

[Thiago_Justen_]

I'd suggest you something like this:

Cheers