Expression(WTD)

[NavinReddy]

Hi Community,

some one help me i need to be find out week to date calls,

my should be starts from sunday

sunday-till date how can i able to find out the cals(WTD)

thanks in advance

Rohith

[tresesco]

try something like:

Count(if(inWeekToDate( CallDate,vToday,-1), Calls))

[er_mohit]

try this

WTD:

Count({<Date={'>=$(=(Num(WeekStart(Max(Date)))))<=$(=(Num(Date)))'}>}Calls)

or you can simply create a field in script

load Date, Sales ,

Weekstart(Date) as WeekStartDate From xyz.

     Now use the WeekStartDate in your chart.

     Hope the idea is clear.

[NavinReddy]

expression not working for me

Sunday -till date

thanks,

rohith