5 Replies Latest reply on Jan 30, 2017 7:33 AM by Lior Barak

    How to Compare date X with date X-90

    Lior Barak

      Hi everyone,

      I know this will be a super stupid question but I can't find a solution at this point, and time is not on my side.

      What I wish to present is a list of dates, the value they had, and the value - 30 days


      SUM( IF [Dt] = DATEADD('day', -30, [Dt]) THEN ZN( [QAU] ) ELSE 0 END )


      I remember this never worked for me in the past, but there was a work around, can someone give me a hand here.