Error when using variables in set analysis ?

[Anonymous]

Hi,

I've decalred a variable in the frontend which picks up the current year

V_CurrentYear  which contains the formula max(year)

though in the text box when tested it gives me the correct value ..ie 2013

but when used in an expression ..doesn't give any value (gives 0 as value which is wrong)

sum({<REPORT_DATE=V_CurrentYear>}CD_count)

Could some one correct my mistake

~B

[#2 · Accepted solution]

Try

sum({<REPORT_DATE={"$(V_CurrentYear)"}>}CD_count)

[#3]

Try:

sum({<REPORT_DATE={$(V_CurrentYear)}>}CD_count)

[Anonymous]

Thank you Becca and Juan ..both the solutions work ..:)