Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED
Create variables in the query expression editor
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?
1 Accepted Solution
Correct answer by
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'))
Correct answer by
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'))
