Problem with $ in Variable Definition in Script

[azimabadi]

Hi.

i define variables in my script. i read some data from excel fiels and construct my variables. but i have a problem wit $ in defination.

consider this :

SET yearString='Kalender.Jahr';
SET sumString = 'Field_a - Field_B';
LET mainString = '( sum ({<' &
  yearString & '={"' & '$' & '(=max(Kalender.Jahr)-' & n & ')"}>} ' &
  sumString & ' ))';

i need to get the following:

( sum ({<Kalender.Jahr={"$=max(Kalender.Jahr)-1"}>} Field_a - Field_B )) 

insted the answer is:

( sum ({<Kalender.Jahr={"(internal error)"}>} Field_a - Field_B )) 

what that is really intersting is that i used the same syntax in another qvw and it works as i expected.

Best Regards

Peyman

[Anonymous]

just tried your script to calculate the variables..

works perfectly well.. as your expected result..

[azimabadi]

as i said it works in one qvw and exactly same syntax gives me 'Internal Error'.

[azimabadi]

here i attach the example where i get 'Internal Error'.

[Anonymous · Accepted solution]

pleace check attached..

hope that helps..