Set Analysis

[#1]

Hi All,

I am Trying to set up some set analysis,

=Sum({'$(vSet)'<CAL_YEAR = {$(vCurrYear)}, CAL_MONTH_NAME_SHORT={$(vPrevMonth)}, [DAY_OF_MONTH]<{$('<vCurrDayD')}>} calls_offered)

Where vSet is either 1 or $

vCurrYear=Current Year =2014

vPrevMonth= Previous Month=7

vCurentDayD=Current Day of Month =10

If I Remove this section :[DAY_OF_MONTH]<{$('<vCurrDayD')}, everything works, this section is there to determine the current day and calculate all calls offered for the same period in the last month to this date

What am i doing wrong?

Cheers

[jonathandienst]

Hi

This is the correct syntax

[DAY_OF_MONTH] = {'<$(=vCurrDayD)'}

HTH

Jonathan

[jagan]

Hi,

Try this expression

=Sum({'$(vSet)'<CAL_YEAR = {$(vCurrYear)}, CAL_MONTH_NAME_SHORT={$(vPrevMonth)},

[DAY_OF_MONTH]={'<$(=vCurrDayD)'}>} calls_offered)

Hope this helps you.

Regards,

Jagan.