AnsweredAssumed Answered

truncating zero character after decimal (Velocity)

Question asked by Mark Price on Sep 6, 2019
Latest reply on Sep 6, 2019 by Sanford Whiteman

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? 

Outcomes