2 Replies Latest reply: Sep 3, 2015 4:11 AM by Sunny Talwar RSS

    How to condition a simple expression

      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