3 Replies Latest reply: Nov 29, 2016 3:15 AM by Paul Senior RSS

    today() and analysis sets

    Paul Senior



      I'm trying to calculate sales [tamount] dynamically for the past 90 days, from a larger set of data. The [tdated] field is a timestamped date field.


      I can get it to calculate sales for 1 day, 90 days ago, by using a = sign in the expression, thus:


      sum({$<[tdated]={'$(=timestamp(today()-90))'}>} [tamount])


      but when I change the = sign to a > sign, I get nothing! i.e.


      sum({$<[tdated]={'$(>timestamp(today()-90))'}>} [tamount])

      Same thing happens if I use greater than or equal to...  >=

      Am I missing something obvious here?