Variables in set analysis is not working

[#1]

Hi

I have scenario,

I have data upto next  20 years from last couple of years

Example my database is from

2005-01-01 to 2016-09-01(current month) and i am adding next 20 years data i.e.2036-09-01

i want to show database max value sales like below

sum({<Date = {$(V_DB_Max_date)}>} Sales)

here Date is number format

If i give sum({<Date = {42614}>} Sales) it is working fine

Please do the needful

Thanks

Thiru

[sunny_talwar · Accepted solution]

Try this may be:

Sum({<Date = {$(=V_DB_Max_date)}>} Sales)

or

Sum({<Date = {$(=$(V_DB_Max_date))}>} Sales)

[Anonymous]

Hi Thiru, try this

sum({<Date = {$(=Date(V_DB_Max_date))}>} Sales)

Regards!