SOLVED

Re: Display of Numbers

Go to solution
Anonymous
Not applicable

Display of Numbers

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

pastedImage_0.png<== this is how I see it in lead detais

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
SanfordWhiteman
Level 10 - Community Moderator

Re: Display of Numbers

In Velocity

$number.integer(<field>)

is yes-comma, no-decimals.

View solution in original post

6 REPLIES 6
Darrell_Alfons2
Level 10 - Champion Alumni

Re: Display of Numbers

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
Level 10 - Community Moderator

Re: Display of Numbers

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

SanfordWhiteman
Level 10 - Community Moderator

Re: Display of Numbers

In Velocity

$number.integer(<field>)

is yes-comma, no-decimals.

Anonymous
Not applicable

Re: Display of Numbers

Thanks,

It works great!

SanfordWhiteman
Level 10 - Community Moderator

Re: Display of Numbers

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

Anonymous
Not applicable

Re: Display of Numbers

done