Set Analysis and Variables

[#1]

   Hi All,

I Created a variable call vCdate

let vCdate=date(now()-1, 'YYYY-MM-DD');

i then have this set expression in my chart

sum({$<DTE=$(vCdate)>} Calls_off)

It returns 0, when i know the value is close to 50K

what am i doing wrong?

thanks

[tresesco · Accepted solution]

Try like:

let vCdate=date(Today()-1, 'YYYY-MM-DD');

sum({$<DTE={'$(vCdate)'}>} Calls_off)

[#3]

Hi Stephen,

Please change the expression to

sum({$<DTE={$(vCdate)}>} Calls_off)

Regards,

Faisal

[#4]

Ok so now i have the next part of this...

On month Level, so again i have created a variable

let vCmonth=if(date(today()-1)=1,month(AddMonths(today()-1, -1)),month(today()-1));

and the set expression is:

sum({$<month(DTE)=$(vCmonth)>} Calls_off)

again it is failing, when you correct me, could you explain what i am doing wrong as this is getting frustrating

[#5]

Ok so now i have the next part of this...

On month Level, so again i have created a variable

let vCmonth=if(date(today()-1)=1,month(AddMonths(today()-1, -1)),month(today()-1));

and the set expression is:

sum({$<month(DTE)=$(vCmonth)>} Calls_off)

again it is failing, when you correct me, could you explain what i am doing wrong as this is getting frustrating