Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this may be:
Sum({<Date = {$(=V_DB_Max_date)}>} Sales)
or
Sum({<Date = {$(=$(V_DB_Max_date))}>} Sales)
Try this may be:
Sum({<Date = {$(=V_DB_Max_date)}>} Sales)
or
Sum({<Date = {$(=$(V_DB_Max_date))}>} Sales)
Hi Thiru, try this
sum({<Date = {$(=Date(V_DB_Max_date))}>} Sales)
Regards!