2 Replies Latest reply: Sep 25, 2015 2:08 AM by Sasidhar Parupudi RSS

    Invalid Expression

    Gareth Cox-Thorpe

      Hi all,

       

      Could someone explain why this expression isn't valid in the script.

       

      if(max(UNIT.SOLD_DATE) > AddMonths(today(),-3), 'Active') as BUYER_BUYING_STATUS,

       

      I'm trying to group buyers that have bought within the last 3 months if they have mark them as 'Active'.

       

      Thanks

       

      Gareth