Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
I have a variable that calculated correctly and I verified it using a text box.
I want to use the value of this variable in the below set expression:
='$'&NUM(ROUND(SUM({$<calendar_date_num = , business_date_num = {'$(=vMaxBusinessDate)'}>} '$(=vDerivedName)'),'###,###,###,###')
OR
='$'&NUM(ROUND(SUM({$<calendar_date_num = , business_date_num = {'$(=vMaxBusinessDate)'}>} {<$(=vDerivedName)>}),'###,###,###,###')
To explain it in other words, what I am trying to do is in a set expression like SUM({<Year=2007>}sales), I am trying to dynamically change the 'sales' field based on the value of a variable. Would be great is someone can help me on this issue. Am I messing up with syntax?
Thanks
Raghu
If vDerivedName evaluates to a field name then use SUM({$<calendar_date_num = , business_date_num = {'$(=vMaxBusinessDate)'}>} $(=vDerivedName))
If vDerivedName evaluates to a field name then use SUM({$<calendar_date_num = , business_date_num = {'$(=vMaxBusinessDate)'}>} $(=vDerivedName))
Hey..thanks.
I was able to figure out the solution. And its exactly the same as you mentioned above. I was also missing a date format.
Thanks
Raghu