Annual Revenue Token

[Anonymous]

I'm trying to use the {{Company.Annual Revenue}} in my email, but when it generates it shows 123456789 rather than $12,345,789. What do I need to do for my email to show the currency format rather than just the plain numbers?

[Josh_Hill13]

You can use velocity or you can try to change your field type to Currency.

You may have better luck going to your CRM Admin to check the field type and formatting and if that's getting into marketo.

[Anonymous]

I was able to check the field type and it's already set to Currency. How would we go about using velocity? Would it be using an Email Script under My Tokens under the campaign? And what's the difference between using the {{Company.Annual Revenue}} token and the {Lead.AnnualRevenue} token?

[Anonymous]

Hi Chris,

See some examples of Velocity scripting at,

http://developers.marketo.com/email-scripting/examples/

In your original question you said that you are trying to use the {{Company.Annual Revenue}}

The answer is whatever field is populated with the correct data.

regards

Rajesh Talele

Note: Velocity scripting only 'formats the data for display. The field value remains unformatted.'

[SanfordWhiteman]

The Velocity code you need is:

${esc.d}${number.format($lead.AnnualRevenue)}

Note you don't want .currency() within Velocity (regardless of the Marketo field type) because that will add decimal points for integer dollar amounts.