5 Replies Latest reply on Feb 13, 2018 10:43 AM by Joe Oppelt

    If Statement for Date

    ljubomir stajic

      Hi guys,

       

      I need some help with a calculated field.

       

      The gray and the blue line in the attached file represent plan and actual year-over-year growth.

       

      I'm trying to come up with a formula to control the blue line as it is misrepresenting what's actually happening.

       

      Basically, I would like it to not show 2019 data at all.

       

      Since the two graphs share a the same date field, I believe this will need to be done using an IF Statement.

       

      Thank you!