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.