5 Replies Latest reply on Oct 4, 2018 11:44 PM by Deepak Rai

    Different results while using else

    Kashish Bhola

      Hello All!

       

      I just encountered one strange thing and  I'am not able to analyse it.

      I was just finding the latest date sales using calculated field and I used the formula :

      IF [Order Date]={MAX([Order Date])} then [Sales] end And this works perfectly but when i am giving '0' in the else condition the rest of the values are becoming '0'

      But when I'am giving '2' in the else condition i am getting some weird results.

      So I just wanted to know on what basis it is giving such results?

      Calc1.PNG

       

      Thanks In Advance!

       

      Regards

      Kashish