Issue with set analysis expression

[#1]

Hi,

Can anyone please let me know what's the error in this expression:

=sum({<[Report Date]={'>=$(vToDateMonthStart) <=$(vToDateMTD)'}>} [New Issuance])

vToDateMonthStart and vToDateMTD are variables.

vToDateMonthStart returns 11/1/2015

And vToDateMTD  returns 11/28/2015

Regards,

Sachin

[sunny_talwar · Accepted solution]

Have you tried with Double quotes instead of single quotes?

=Sum({<[Report Date]={">=$(vToDateMonthStart) <=$(vToDateMTD)"}>} [New Issuance])

or try this

=Sum({<[Report Date]={"$(='>=' & $(vToDateMonthStart) & '<=' & $(vToDateMTD)"}>} [New Issuance])

[#3]

Hey Sunny,

Thank you.

=sum({<[Report Date]={'>=$(vToDateMonthStart) <=$(vToDateMTD)'}>} [New Issuance]) ---- worked

[sunny_talwar]

‌So your original expression worked?

[#5]

Yeah, I didn't understand what went wrong initially. I have been breaking my head since past 2 hrs and then it just worked.

Anyways thanks for the prompt and quick reply, Sir.

[sunny_talwar]

Hahahaha no problem . I would recommend marking your own answer as correct (as technically yours is the correct answer) as it might help some one else in the future.

Best,

Sunny