Hi there.
OK, after a number of hours going round the subject, I ask you to please help me with the following set analysis expression.
The data structure is as follows (illustrative):
| Invoice_num | Date_field |
| 10221 | 10/04/2014 |
| 10222 | 11/04/2014 |
| 10223 | 11/04/2014 |
| 10224 | 11/04/2014 |
| 10225 | 12/04/2014 |
| 10226 | 12/04/2014 |
| 10227 | 14/04/2014 |
| 10228 | 15/04/2014 |
| 10229 | 16/04/2014 |
| 10230 | 16/04/2014 |
| 10231 | 16/04/2014 |
Now, considering the most recent date in the Date_field I'd need to count how many invoices have been issued in the last 30 days. I.e. if the most recent date is 16/04/2014, I should be considering invoices issues from 17/03/2014 on.
I've found some similar unsolved questions and the expression I've managed to get is something like this:
Count({$<Date_field={">=$(=max(Date_field)-30)"}>}Date_field)
But it doesn't work. It returns 0.
I don't know if it has to do with data format or if it's just a syntax problem.
As always, many thanks in advance.
M.
