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..

[jyothish8807]

Hi,

Try this:

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

REgards

KC

[alexandros17]

is vMillion a variable? If yoe try $(vMillion)

[ashfaq_haseeb]

Hi,

make sure you have proper date format,

Then try below

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

Or

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

Regards

ASHFAQ

[#5]

Try this,

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

[stabben23]

If you have sum in your variable then you have to move it outside expression, like Ashfaq shows.

[alkesh_sharma]

Nope, Its giving me 0, which is not correct.

[alkesh_sharma]

This is just to convert the value in Millions, Even if I remove this, the problem is the same.

[jyothish8807]

Hi Try this:

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

If you still face issue, then check your variable ina text box and see yhe output:

In text box:

=$(vCutoffDate)

Regards

KC

[alkesh_sharma]

Hello Jyothish,

=$(vCutoffDate) is giving me -20, 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.