Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm using this expression
=sum ({<KeyFecha=, FECHA_CERTIFICACION = {"$(= '>=' & $(vFechaFinalFormato) & '<=' & $(vFechaInicialFormato))"}>} MONTO_USD_MIL)
Now i wanna use this set analysis in 80 or 100 expressions
{<KeyFecha=, FECHA_CERTIFICACION = {"$(= '>=' & $(vFechaFinalFormato) & '<=' & $(vFechaInicialFormato))"}>}
Can i put this in a variable? because if in the future i have to change i'll have to copy and paste a lot..
greetings
Never tried it, but I think it should work.
UPDATE: Seems to be working in the below sample
You should be able to do this without any issue. The only concern is that if one of the expression needs to have an extra set analysis condition, you won't be able to add a variable + add an extra condition. You will then need to remove the variable and add the whole set analysis statement with the additional condition into your expression.
Note: Expression Editor may show that there is syntax error, but it should work fine.
You're right but maybe can i do something like this
vVariable = FECHA_CERTIFICACION = {"$(= '>=' & $(vFechaFinalFormato) & '<=' & $(vFechaInicialFormato))"}
Expression =sum ({<KeyFecha=, $(vVariable)>} MONTO_USD_MIL)
is that gonna work ?
Never tried it, but I think it should work.
UPDATE: Seems to be working in the below sample
Yes it´s working
Regards