Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like:
let vCdate=date(Today()-1, 'YYYY-MM-DD');
sum({$<DTE={'$(vCdate)'}>} Calls_off)
Try like:
let vCdate=date(Today()-1, 'YYYY-MM-DD');
sum({$<DTE={'$(vCdate)'}>} Calls_off)
Hi Stephen,
Please change the expression to
sum({$<DTE={$(vCdate)}>} Calls_off)
Regards,
Faisal
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
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