Error in Set Expression

[alkesh_sharma]

Hello All,

I am Using the following Expression:

=Sum({<[Revenue.Invoice Date] = {$(vCutoffDate)}>} [Revenue.Invoice Amount]/vMillion)

Its returning me an Error: ERROR in SET MODIFIER, ',' or ')' Expected.

Need Help..

[alkesh_sharma]

Hello GUys Please Help,

Its Ugent,

=$(vCutoffDate) in a text box,  is giving me -20, but =vCutoffDate in a text Box is giving me '02-11-11' which is correct. I guess there is the problem.

But I am using the same variable to calculate >=Start Date to < CutoffDate which is working fine,

Also used it in >CutoffDate to <=EndDate which is also working fine,

Only = CutoffDate is not working.

[ashfaq_haseeb]

Hi,

Can you share sample application to look over.

Regards

ASHFAQ

[stabben23]

Try this: {'$(=Date(vCutOffDate))'}...

[jyothish8807]

Hi Alkesh,

In your variable module where you have declared the variable, add a = in the begining of the variable declaration

ed:

=Max(Year)  instead of max(Year)

Regards

KC

[alkesh_sharma]

This Variable is entered by the user through an Calender Object.

I already changed the number format in the calender object as Date 'DD-MM-YYYY'

[alkesh_sharma]

That Would be a little Difficult..Sorry!

[alkesh_sharma]

NO, The answer is still 0,

[ashfaq_haseeb]

It is difficult to tell without seeing.

Contact me on skype

my skypeID: ashfaqhaseeb

Regards

ASHFAQ

[stabben23]

But you have 'DD-MM-YY' in your variable you says.

[alkesh_sharma]

I am in Office, Can't connect now...:(