7 Replies Latest reply: Sep 22, 2016 6:28 AM by Amit Saini RSS

    Remove Null values in Text box calculation

    Amit Saini

      Hi Folks ,

       

      I'm having below expression in text box:

       

      ='€' & Num($(eSALES_ACTUAL) / 1000000, '####') &' M'

       

       

      I want to show in calculation when Plant >0 , I want to avoid numbers for null values of Plant.

       

      Please suggest!

       

      Thanks,

      AS