truncating zero character after decimal (Velocity)

Question

Seeing a strange issue with a Velocity script and am hoping someone can save my sanity.

I'm looping over a custom object and extracting values to pull into the email.

There's a currency field in salesforce called Amount__c that seems to just remove trailing 0s after a decimal when Marketo reads the value.

Example of variable being set:

#set( $regRefundAmount = "${esc.d}${Automated_Fee_Reimbursement__c.Amount__c}" )‍

Example Test #1
402.76 turns into:

$402.76

Velocity Output for custom object values:
{Address_Change_Expiration_Date__c=2019-09-17, Amount__c=402.76}

Example Test #2
11.40 turns into:

$11.4

Velocity Output for custom object values:
{Address_Change_Expiration_Date__c=2019-09-17, Amount__c=11.4}

Example Test #3:
60.00 turns into:

$60

Velocity Output for custom object values:
{Address_Change_Expiration_Date__c=2019-09-17, Amount__c=60}

If I go to SalesForce it will show $11.40 and $60.00 opposed to what the velocity output is showing (?)

Any ideas?

SanfordWhiteman · Accepted Answer

Not too weird really, floats don't have a fixed number of decimal points to display. Once they get stringified (= display-ified) they're going to keep the shortest possible representation. To display as USD currency with 2 decimals, pass the field to

$number.currency()‍

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded