Display of Numbers

[Anonymous]

Hi all,

I have a SFDC custom field that syncs to Marketo. The field type in SFDC is "double" and in Marketo is "float". The field is in use in about 50 email, smart lists and flows.

When I look at the data from SFDC I see this display: 12,000 (with a comma) but when I try to use it as a token in email I see it without a comma (12000). Is there a way to show number with this comma? (I tried all the options. Changing field type is not an option since I need its numerical value for smart lists).

<== this is how I see it in lead detais

Thanks

[Darrell_Alfons2]

I don't believe this is possible in Marketo. You will probably have to create another field in SFDC that is a formula field, have that populate with the comma, and sync that field over to Marketo.

[SanfordWhiteman]

Of course it's possible. This is core functionality offered by Velocity (email script tokens).

[SanfordWhiteman · Accepted solution]

In Velocity

$number.integer(<field>)

is yes-comma, no-decimals.

[Anonymous]

Thanks,

It works great!

[SanfordWhiteman]

Great, if you can mark my answer as Correct when you get a chance...

[Anonymous]

done