This content has been marked as final. Show 3 replies
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:
but when I change the = sign to a > sign, I get nothing! i.e.
Same thing happens if I use greater than or equal to... >=
Am I missing something obvious here?