How to condition a simple expression

[#1]

Hello,

I am sure this is a silly-easy question but I am new and learning to please be patient :

I have the following expression in a Pivot Table Chart with Sales and Day\Month\Year dimensions (among others) : 

Sum (sales) - Above (Sum (Sales))

How Can I add a condition that when sum (sales) = 0  than  either show an error or do not show any value for the expression in the Chart

(Since when Sum can not be zero, it indicate the data was not loaded in that Date)

(Sum (sales) - Above (Sum (Sales)))

Thank

Nir 

[alexandros17 · Accepted solution]

Something like.

If(Sum (sales) - Above (Sum (Sales))<>0, Sum (sales) - Above (Sum (Sales)), 'Not Avail.')

[sunny_talwar]

May be this:

If(Sum(sales) <> 0, Sum(sales) - Above(Sum(Sales)))