Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
file excel with ewpresion sunny
Checking
yes paradosh i check it
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)','@','$');
19 | 15 | Production crédit consommation | CLASSE MOYENNE |
yes Anil the dollar sign expansion is getting evaluated ,so i need ingnoring thisevaluation in script
y mean
LET _varName = Peek('desc_expression',$(_i),[Expression_list]);
LET _varValue = Peek('Expression',$(_i),[Expression_list]);
Let [$(_varName)] =Replace('$(_varValue)','@','$');
Yes, you will first need to replace the $ characters with @ in the excel first off course (or when loading)
Piet is right, try like attached
really thank you thank you, you helped me a lot I'm stuck for a few days