Trying to get $ figure through velocity scripting... help? | Community
Skip to main content
Jervis_Koo
Jervis_Koo
New Participant
January 7, 2020
Solved

Trying to get $ figure through velocity scripting... help?

  • January 7, 2020
  • 1 reply
  • 5421 views

Hey! 

We're currently using velocity script tokens for dynamic content on our emails and currently having some challenges with getting the script to show a dollar amount with the $ format. 

I was expecting the field lead.yearlyAmount to spit out the amount with the $ sign (field type is currency) but I guess that's not how it works so we've tried using the script below to no avail. The script doesn't seem to be parsing - any ideas?

#set($yearlyCurrency = $number.toNumber($lead.yearlyAmount))
$esc.dollar$number.format('#,###', $yearlyCurrency)‍‍

Any help would be appreciated!

Jervis

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

First: you should never use Currency -- for anything -- despite the name. For round numbers, use Integer. For numbers with decimals, use scaled Integers (value * 100) and scale them back in Velocity or JS.

Also, please highlight code when posting using the syntax highlighter so it's readable. Highlight as Java as it's closest to VTL.

You don't need to convert to a Number (Double) separately, $number.format() does that conversion internally. Make sure you escape all your special Velocity symbols.

${number.format("${esc.d}${esc.h},${esc.h}${esc.h}${esc.h}", $lead.yearlyAmount)}‍‍

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
January 7, 2020

First: you should never use Currency -- for anything -- despite the name. For round numbers, use Integer. For numbers with decimals, use scaled Integers (value * 100) and scale them back in Velocity or JS.

Also, please highlight code when posting using the syntax highlighter so it's readable. Highlight as Java as it's closest to VTL.

You don't need to convert to a Number (Double) separately, $number.format() does that conversion internally. Make sure you escape all your special Velocity symbols.

${number.format("${esc.d}${esc.h},${esc.h}${esc.h}${esc.h}", $lead.yearlyAmount)}‍‍
    Jervis_Koo
    Jervis_KooAuthor
    New Participant
    January 7, 2020

    Worked perfectly! Was doing my head in for a good few weeks.Thank you @Sanford Whiteman‌! 

    *also edited to highlight code 

      SanfordWhiteman
      SanfordWhiteman
      New Participant
      January 7, 2020

      Thanks a lot for the highlighting, helps others remember.

      Terms & ConditionsAccessibility statement

      Loading footer...