Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)