내 커뮤니티 업적 표시줄을 확대합니다.

Submissions are now open for the 2026 Adobe Experience Maker Awards

Mark Solution

활동이 없어 이 대화는 잠겼습니다. 새 게시물을 작성해 주세요.

해결됨

Create variables in the query expression editor

Avatar

Level 7

Heku__0-1680681199938.png

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 채택된 해결책 개

Avatar

정확한 답변 작성자:
Community Advisor

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'))

원본 게시물의 솔루션 보기

1 답변 개

Avatar

정확한 답변 작성자:
Community Advisor

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'))