Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
can someone help me in understanding what is wrong with this expression?? I am having trouble with the vToday variable:
=sum({<DTA_MAKEDATE= {'$(=Date(monthname($vToday,-1),'MM/YYYY'))'}>} PDT_DBL_AUM)
Tx
try enclosing your variable with (), $(vToday)
There are brackets missing
=sum({<DTA_MAKEDATE= {'$(=Date(monthname($(vToday), -1),'MM/YYYY'))'}>} PDT_DBL_AUM)
Try this:
=sum({<DTA_MAKEDATE= {'$(=Date(monthname($(=vToday,-1)),'MM/YYYY'))'}>} PDT_DBL_AUM)
Thanks,
AS
Try this one:
=Sum({<DTA_MAKEDATE = {'$(=Date(monthname($(vToday,-1)),'MM/YYYY'))'}>} PDT_DBL_AUM)
HTH
sushil