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

[jonathandienst]

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)