set analysis for date

[#1]

Hi,

I am trying to make a table with data for the past 5 days. This is the expression I am using:

Sum( {$< EventDate = {'$(vMaxDate)'},Account= -{'500','400'} >} Revenues).

What is the correct way to write this expression so that I have vMaxDate-1, vMaxDate-2......vMaxDate-5 in the set analysis? I have tried having the "-number" in different places in the equation but I keep on getting 0. Help appreciated.

Cheers.

[CELAMBARASAN]

Try kind of this

Sum( {$< EventDate = {'>$(=Date(vMaxDate-5))<=$(=vMaxDate)'},Account= -{'500','400'} >} Revenues)

[MK_QSL]

=SUM({<EventDate = {">=$(=Date($(vMaxDate)-4,'DD/MM/YYYY'))<=$(vMaxDate)"},Account= -{'500','400'}>}Revenues)

[#4]

didn't work, still getting no values

[#5]

didn't work, still getting no values

[#6]

didn't work, still getting no values

[MK_QSL]

What is the definition of your vMaxDate?

[#8]

= If(WeekDay(Max(EventDate)) = 'Sat', Date(Max(EventDate)-1),

  If(WeekDay(Max(EventDate)) = 'Sun', Date(Max(EventDate)-2),

  Date(Max(EventDate))))

We have no data on saturday and sundy. the date is in this format: 25.07.2014

[MK_QSL]

Try this....

=SUM({<EventDate = {">=$(=Date($(vMaxDate)-4,'DD.MM.YYYY'))<=$(vMaxDate)"},Account= -{'500','400'}>}Revenues)

[aveeeeeee7en]

Try something like this:

Sum({<EventDate={'$(=(vMaxDate))'},Account={'*'}-{'500','400'}>}Revenues)

Regards

Aviral Nag