5 Replies Latest reply on Mar 13, 2017 3:28 PM by Mike Janecek

    Using LODs in an if statement to get values for 1 day/7days prior

    Mike Janecek

      Using V10.1

       

      Hello,

      I am trying to get values across today, 1 day prior, and 7 days prior.  I cannot change the input data format.

      Values I am getting:

      The today and 1/7 day prior are giving me the same result.

      1/7 day prior should not be the same value as today. However 1/7 day prior should be somewhere in the realm of the today value.

       

      These are the calcs I'm using:

       

      What I need to happen: 1/7 day prior should not be the same value as today. However 1/7 day prior should be somewhere in the realm of the today value shown above.

       

      Thanks in advance for any help.  I've attached a wkbk.

       

      Mike J