Weekday issue help!!

[#1]

Hi All

what i expect is  - when i select sunday's of the month=6 as per weekday , it should show data from <fri - sunday>,else normal.

what i am getting is - for the first sunday i m getting wrong data , rest 3 sunday's its fine.....

Please find below the logic I am using in my expression to get the output.

=if(Weekday(vCalendar)<>6

,sum({<[Sales Stage Date]= {"$(=Date(vCalendar,'DD/MM/YYYY'))"},[Involvement] = {'with Services', ' not with Services'}>}[Amount])

,sum({<[Sales Stage Date]= {">=$(=Date(vCalendar-2,'DD/MM/YYYY'))"}*{"<=$(=Date(vCalendar,'DD/MM/YYYY'))"}

,[Involvement] = {'with Services', ' not with Services'}>}[Amount]))

Please suggest

Thanks in Advance

Timba

[jonathandienst]

The is the correct syntax for the second part of your expression:

sum({<[Sales Stage Date]= {">=$(=Date(vCalendar-2,'DD/MM/YYYY')) <=$(=Date(vCalendar,'DD/MM/YYYY'))"}, Involvement = {'with Services', ' not with Services'}>} Amount)

[#3]

Hi Jona

Issue is still the same even after using the above querry in expression,its showing data for first sunday of every month.............where as i want  no data on sundays

Thanks

Timba