SHow last 15 Days of Activity

[james]

Has anyone gotten an expression to work where you show the last 15 days worth of activity, i.e revenue.

i was using this sum({$<Year = {$(=only(Year))}, Date= {">=$(=max(Date)-15)"}>} Revenue)

but wasno good

[johnw]

Probably tell it to ignore the Year and just go on date, and you'll probably need to format as a date. So if Date is in 'MM/DD/YY' format, something like this:

sum({<Year=,Date={">=$(=date(max(Date)-15,'MM/DD/YY'))"}>}Revenue)

[james]

John - Thnaks for the reply, it is still is not giving any result

[james]

sum

({$<Year = {$(=only(Year))},Date={">=$(=date(max(Date)-15,'MM/DD/YYYY'))"},[Revflag] = {'0'},[RevType] = {'Revenue'} > } [TotalAmount

This expression doesnt seem to work. Yet when you select RevType as a drop down and select Revenue, the data appears.

[james]

Anyone know an easy way to show last 15 days activity? Not using Date field but vToday

[johnw · Accepted solution]

Attached file shows doing it with max(Date) using the exact expression I posted earlier, and with vToday by simply replacing max(Date) with vToday.

[james]

John, Thanks!