To aggregate the sum in Campaign export template from AJO | Community
Skip to main content
Level 4
March 1, 2025
Solved

To aggregate the sum in Campaign export template from AJO

  • March 1, 2025
  • 1 reply
  • 363 views

how can I aggregate cheque_amount1 + cheque_amount2 = Totalvalue via export template of the DM Campaign?

 

Thank you.

Best answer by SatheeskannaK

@chrisyan I don't think you will be able to assign the value and use that as input to another label in the DM export. Instead, try using a personalization function along these lines, or else if the cheque_amount data is in the profile level you can do personalization functions to calculate the data field,

{% let cheque_amount1 = 10 %}
{% let cheque_amount2 = 20 %}
{% let Totalvalue = cheque_amount1 + cheque_amount2 %}
{{Totalvalue}}

1 reply

SatheeskannaK
Community Advisor
SatheeskannaKCommunity AdvisorAccepted solution
Community Advisor
March 1, 2025

@chrisyan I don't think you will be able to assign the value and use that as input to another label in the DM export. Instead, try using a personalization function along these lines, or else if the cheque_amount data is in the profile level you can do personalization functions to calculate the data field,

{% let cheque_amount1 = 10 %}
{% let cheque_amount2 = 20 %}
{% let Totalvalue = cheque_amount1 + cheque_amount2 %}
{{Totalvalue}}

Thanks, Sathees