Create variables in the query expression editor

[Heku_]

I have this expression, and i would like to move (openCount*100/deliveryCount) to a variable in that expression to make it more efficient. Is there any way to do that?

[ParthaSarathy · Accepted solution]

You can create a variable (openCount*100/deliveryCount) in query 'Add data' and give an alias to it (eg, @countCalculation).

After query, use an enrichment activity, Add data > here you can use the previously created variable, (eg, Iif(@countCalculation>40,'abc','xyz'))