15 Replies Latest reply: Aug 14, 2015 9:35 AM by neetha P RSS

    Using YTD field in If statement

    Steve Zagzebski

      I am trying to write an if statement in an expression using a YTD (Year to Date) field.

       

      What I want to do is find out if the month "July" falls within the YTD field.

       

      So something like.....If YTD contains July, then 1, else 0.  I just don't know how to make the connection on a value that isn't actually part of the yield biut is associated with it.

       

      Thanks in advance,

       

      Steve