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!