Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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