Display of Numbers | Community
Skip to main content
March 28, 2017
Solved

Display of Numbers

  • March 28, 2017
  • 2 replies
  • 3316 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman

In Velocity

$number.integer(<field>)

is yes-comma, no-decimals.

2 replies

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
March 28, 2017

In Velocity

$number.integer(<field>)

is yes-comma, no-decimals.

March 29, 2017

Thanks,

It works great!

SanfordWhiteman
New Participant
March 29, 2017

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

Darrell_Alfons2
New Participant
March 28, 2017

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
New Participant
March 28, 2017

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