set with variable

[Chanty4u]

Hi all,

 Sunny_talwar

i have variable    like below   im using in this in set analysis but its showing error in expression..  

vCurHalf_Year = chr(39)&concat(Half_Year,chr(39)&','&chr(39))& chr(39)

textbox expression:    =sum({$<Half_Year={(=$(vCurHalf_Year)},Type={'Forecast_SR','Forecast_SSR'}>}Service_Amount)

what might be the issue?

Thanks

[sunny_talwar · Accepted solution]

May be try one of these

=Sum({$<Half_Year = {$(=$(vCurHalf_Year))},Type = {'Forecast_SR', 'Forecast_SSR'}>} Service_Amount)

Or this

=Sum({$<Half_Year = {$(vCurHalf_Year)},Type = {'Forecast_SR', 'Forecast_SSR'}>} Service_Amount)

[Chanty4u]

thanks sunny.. 1st one is working .. 2nd one showing expression error.