Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
If I have
-Part Number
- Description
- Onhand-Qty
as columns in a table, how do I prevent rows where the 'Onhand-Qty' = 0 from being shown?
I've tried Aggr function, If statement etc, but can't figure it out.......
I can suppress the '0' and get '-' instead, but I can't get the rows to be excluded.
Thanks.
you could use set Analysis Statement in your Expression
sample Expression:
=Sum({$<Onhand-Qty={0}>}TEST)
Thank you for your reply.
Do you mean I should have this expression against the OnhandQty field's expression?
I've tried this:
=Sum({$<OnhandQty={0}>}OnhandQty)
but it doesn't have any afffect.
Or do you mean something else?
Thanks,
yeah that's right. If you have more Expressions you have to do it in every Expression to exlude this data.
Hi,
you have to do it with a set analysis statement , here is below screenshots show you the formula to avoid zero values and result
as you can see i exclude the 0 value from the table.
Hi Stephen,
Just, select the table on right side, click on Add-ons and Unselect the "Include Zero Values"
and if you don't want to show the null values in the table which display as '-'
On right side, select your dimension and unselect "Include Null values"
Thanks very much for your response... much easier than I'd though - i think I actually have some very very small qty that appear as 0 but aren't.
Thanks a lot.
Thanks a lot for your help.
Good !!
Close the thread by marking the correct answer..!!
Great, thanks for your help