How To Hide Negative Values

[#1]

Dear All,

I have used 2 tables for the calculation ( suppose table A & table B) & used the expression A-B, and make a chart (pivot table)

i just want to supress negative values in the output chart.

Thanks in advance

[Gysbert_Wassenaar · Accepted solution]

You can try adding an if statement around your expression: if(A-B>=0, A-B). If that doesn't do what you need, please post example data and an example of what the result should look like.

[#3]

Thanks Gysbert...

[wiz_nerd]

Thanks for the solution 🙂 It works perfectly.