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:

1. Create a custom formula text field.
2. Use this formula below – replace yourFieldNameHere with the actual currency field you want to use.
3. Go to the Predictive Admin tab > Merge Fields page and add the new field to your list of merged fields. Click Save.
4. Go back to your email campaign and click the Synchronize button.
5. The new field will now be available as a merge field in the email editor.
6. 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))
 )

Last update 09/2015

(0)

(0)