Insert decimal into Non number

Tim Krull

• September 21, 2023 20:16

I am working to import cost data into Salesforce, the value lists as 1499, I have tried to use the tofixed function, but it outputs the following when I attempt to transform the value I am getting the following output: NaN1499

 

{{toFixed field 2}}{{plan.amount}}

0

• 

  David Gollom Strategic Partner

  • September 21, 2023 22:10

  

  

  

  

  

  try {{toFixed plan.amount 2}}  everything needs to be inside the handlebars. 

  0
• 

  Tim Krull

  • September 22, 2023 01:56
  • Edited

  

  

  That works to add the decimals to the end, the item cost if 14.99, so I need to insert the decimal at the third and fourth characters essentially.  I have been able to do this with replace, but since there will be multiple values would prefer to be able to simply insert or convert the value to a number or currency.

  0
• 

  Tyler Lamparter Principal Product Manager

  • September 22, 2023 14:53

  

  

  

  

  

  Tim Krull can't you just divide by 100?

  {{divide plan.amount 100}}

  1

Please sign in to leave a comment.