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.