Currency Merge Fields | Predictive Response
Currency Merge Fields
To help ensure that your currency field displays as desired in your campaign email, follow these steps:
- Create a custom formula text field.
- Use this formula below – replace yourFieldNameHere with the actual currency field you want to use.
- Go to the Predictive Admin tab > Merge Fields page and add the new field to your list of merged fields. Click Save.
- Go back to your email campaign and click the Synchronize button.
- The new field will now be available as a merge field in the email editor.
- Add the field to your email (make sure to prepend it with a “$”) and send a test to confirm it displays as desired.
IF( yourFieldNameHere>= 1000000, TEXT(FLOOR(yourFieldNameHere / 1000000)) & ",", "") & IF( yourFieldNameHere >= 1000, RIGHT(TEXT(FLOOR(yourFieldNameHere / 1000)), 3) & ",", "") & RIGHT(TEXT(FLOOR(yourFieldNameHere)), 3) & "." & IF( MOD(yourFieldNameHere, 1) * 100 < 10, "0" & TEXT(ROUND(MOD(yourFieldNameHere , 1), 2) * 100), TEXT(MIN(ROUND(MOD(yourFieldNameHere , 1), 2) * 100, 99)) )