4 Replies Latest reply: Aug 22, 2012 6:15 AM by Aadil M RSS

    Problem with $ in Variable Definition in Script

    Peyman 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