Adding commas to values

[Daniela_Puizina]

Sanford Whiteman Hi Sanford - Continuing the discussion here!

So my comma problem - I'm trying to create this script (below) which works but I don't know what to do about adding a comma to the countless values that could be displayed if under 25k. Any ideas?

#set ($scorecap = $convert.toNumber(${lead.cap25}))#if ( $scorecap > 25000)$25,000#else${lead.cap25}#end‍‍‍‍‍‍

[SanfordWhiteman · Accepted solution]

#set( $scoreCapped = $math.min($convert.toNumber($lead.cap25),25000) )#set( $scoreFormatted = $number.format( "${esc.h},${esc.h}${esc.h}${esc.h}", $scoreCapped ) )${scoreFormatted}‍‍‍

[Daniela_Puizina]

Thank you!!

[SanfordWhiteman]

Sure, let me know if any of the code isn't self-explanatory.