so it seems you need either a set_expression to determine the last 24 months and sum up that field for that period - or you can do it in the script - just calculate an additional field:
- First you have to split out the nr. (day) from that FirstDay_field
-> Then use the MaKEDATE() fct. to construct a date from that
-> Use DATE([field], 'MMM-YY') to have a unique month_year combination
- In addition you have to construct in the script that month_year for today (Jan-15)
=> Then you can construct another field:
- If that month_year >= (today's month_year - 24), THEN just copy the Nr_field
- otherwise, just fill in a 0
=> Then you have a field that you can simply sum up on the GUI.
Thanks for your very quick response! I'm sorry, but I dont see what you mean...
This is the piece of script I have for the table above:
Year(DateApplied) as Year,
Month(DateApplied) as Month,
makedate(Year(DateApplied),Month(DateApplied)) as FirstDayPeriod,
sum(NrOfThings) as NrOfThings
What, in your opinion, is my next step? How do I construct that extra field you mention above?
Thanks in advance!