4 Replies Latest reply on Nov 30, 2017 3:33 PM by simran johal

    Remove Null From 2nd last Purchase orderdate and replace NULL with most recent purchase

    simran johal

      Hi All,

       

      I have used this formula to calculate 2nd last Purchase

       

      {fixed[lower email address]:max(if[Order date]<[MOST RECENT PURCHASE] then[Order date] end)}

       

      and this to calculate most recent purchase

       

      {FIXED[lower email address]:MAX([Order date])}

       

      I want to remove NULL from 2nd last purchase and replace them with most recent purchase. So that when i calculate difference of 2nd last and most recent purchase, I don't get a NULL but a zero. Also attached screenshot for reference.

       

      Regards

      simran