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
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)','@','$');
Can you paste expression?
you need to be more clear with your requirement and as anil said please paste the expression.
sum({<ANNEE = {"=Max(TOTAL (ANNEE))"}, MOIS, MOIS = {"<= MAX(TOTAL(MOIS))"} , DATE_SITUATION,CREDIT_NATURE={"CONSO"},CLIENT_PRE_SEGMENT_A={"HAUT DE GAMME"}>} CREDIT_MONTANT_PRODUCTION )
May be problem due to one field to degrade using multi times
sum({<ANNEE = {"=ANNEE=Max(TOTAL ANNEE)"}, MOIS = {"<=MAX(TOTAL MOIS)"} , DATE_SITUATION,CREDIT_NATURE={"CONSO"},CLIENT_PRE_SEGMENT_A={"HAUT DE GAMME"}>} CREDIT_MONTANT_PRODUCTION )
Anil expression is correct when i used directly in expression , and when i put this expresion in variable didnt work
look this exemple with $ :
um(TOTAL{<ANNEE = {$(=Max(ANNEE))}, MOIS, MOIS = {"<= $(=MAX(MOIS))"} , DATE_SITUATION,CREDIT_NATURE={"CONSO"},CLIENT_PRE_SEGMENT_A={"CLASSE MOYENNE"}>} CREDIT_MONTANT_PRODUCTION )
um(TOTAL{<ANNEE = {$(=Max(ANNEE))}, MOIS, MOIS = {"<= $(=MAX(MOIS))"} , DATE_SITUATION,CREDIT_NATURE={"CONSO"},CLIENT_PRE_SEGMENT_A={"CLASSE MOYENNE"}>} CREDIT_MONTANT_PRODUCTION )
try below
sum({<ANNEE = {"$(=Max(TOTAL ANNEE))"}, MOIS, MOIS = {"<= $(=MAX(TOTALMOIS))"} , DATE_SITUATION,CREDIT_NATURE={"CONSO"},CLIENT_PRE_SEGMENT_A={"HAUT DE GAMME"}>} CREDIT_MONTANT_PRODUCTION )
Regards,
That means, Let's assume your variable called Var1 and expression contains same. Are you going to use Using Parameter level or Plain variable?