big problem with variable and set analysi expression

[souadouert]

HELLO,
I still have problems with the expression set download from a file, the expression gives the right result using direct in a table,

but when I download it since file does not work, I removed the $ and used TOTAL, and nothing has changed

[souadouert]

file excel with ewpresion sunny

[sunny_talwar]

Checking

[souadouert]

yes paradosh i check it

[stigchel · Accepted solution]

Instead of loading the expression with dollar signs you can load for example with @ first and then replace them when assigning to the variables, in example:

Set _varName=vExpression;

Set _varValue=Sum({<Year={"@(=Max(Year))"}>} Value);

Let [$(_varName)] =Replace('$(_varValue)','@','$');

[souadouert]

19

15

Production crédit consommation

CLASSE MOYENNE

[souadouert]

yes Anil the dollar sign expansion is getting evaluated ,so i need ingnoring thisevaluation in script

[souadouert]

y mean

LET _varName = Peek('desc_expression',$(_i),[Expression_list]);

   LET _varValue = Peek('Expression',$(_i),[Expression_list]);

   Let [$(_varName)] =Replace('$(_varValue)','@','$');

[stigchel]

Yes, you will first need to replace the $ characters with @ in the excel first off course (or when loading)

[sunny_talwar]

Piet is right, try like attached

[souadouert]

really thank you thank you, you helped me a lot I'm stuck for a few days