topic Re: today() and analysis sets in App Development

today() and analysis sets

seniorps — Mon, 28 Nov 2016 17:52:21 GMT

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?

Thanks!

swuehl — Mon, 28 Nov 2016 17:54:36 GMT

Try

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

sunny_talwar — Mon, 28 Nov 2016 17:56:48 GMT

You can also try this:

Sum({$<[tdated]={'$(='>' & TimeStamp(Today()-90))'}>} [tamount])

seniorps — Tue, 29 Nov 2016 08:15:46 GMT

Thanks - works perfectly!