0 Replies Latest reply: Aug 27, 2014 7:07 AM by Zotov SERGEY RSS

    how to flag rows with if or set analysis statement

    Zotov SERGEY

      hi i have a table like this(pic below):

      promo column recieved by expression  if(SALEDATE<=ToDate,'Promo','')

       

      but i need Promo marked for 6 days after.

       

      i tried using p() but it didnt worked

      yOWTp1c.png

      i need something like this

      bYBxTzf.png