5 Replies Latest reply on Jan 5, 2018 2:10 AM by Mahfooj Khan

    Need Solutions!!!

    Jervel Peng

      hi all,

      I have attachment excel file, I need to hide all Null in Order Date/Delivery Date/Revised Date. can anyone help me on this? I've tried to change the date to string and write below calculation:

       

      IF [Order Date] = 'Null' AND   [Delivery Date] = 'Null' and [Revised Date] = 'Null'

      THEN 'Hide'

      ELSE 'Show'

      End

       

      but it only give me "show" , attached original excel data. please help me anyone.

      thank you!