3 Replies Latest reply on Feb 17, 2018 10:26 AM by Jim Dehner

    I need an IF statement with both a string and date criteria

    Stephen Hellyar

      I have an Item ID dimension.  I want to zero out the sales for all years after 2017 for a given Item ID.


      I tried to construct the following IF statement .  It is not constructed properly, but it depicts what I am trying to do.


      IF ([ItemID] ="0123" AND [DATE]  >="12/31/2017") THEN [SALES] ="0"


      I'm really at a loss.