Suppressing zero values

[#1]

I have two fields (Orders, Receipt ) put into a chart as an expression but it is just pulling it from a field in a table that has both of these values.  Sometimes, there are orders during certain weeks for some products but other times, it could be zero.

What is the best way to make it so that they do not show when the values for those fields are 0. I tried to 'Suppress 0 values' under the presentation tab for those two specific fields but they don't do anything.

[rwunderlich]

How about:

if(sum(Orders+Receipt), FirstSortedValue( [Transportation_Cost],1))

-Rob

[#3]

Please see all attachments. I don't want it to show the rows that have 0 for orders AND receipts.

[fsimoes81]

Try it:

FirstSortedValue({<[Total cost] = {">0"},Product = {"=Sum(Orders)+Sum(Receipt)>0"} >} [Total cost],1)

[#5]

Sorry, but where do I use that expression?

[fsimoes81]

It depends, if you want to show like your example, you will need to use that expression in all expression.

See this example.