Rounding numbers with velocity

6 replies
2618 views
Translate

I have some data coming in with decimals and I was hoping to round it with velocity. For example, I have some numbers coming in as 34.36 and would like it to show 34.

Marketo

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

SanfordWhitemanAccepted solution

Level 10

Get yourself a proper number-rounder and use it:

#set( $integerFormat = $number.getNumberFormat("integer", $convert.toLocale("en_US")) )
#set( $void = $integerFormat.setRoundingMode($field.in($integerFormat.getRoundingMode()).HALF_UP) )
${integerFormat.format($number.toNumber($lead.YourField))}

(Assuming of course you meant arithmetic rounding.)

SanfordWhitemanAccepted solution

Level 10

Get yourself a proper number-rounder and use it:

#set( $integerFormat = $number.getNumberFormat("integer", $convert.toLocale("en_US")) )
#set( $void = $integerFormat.setRoundingMode($field.in($integerFormat.getRoundingMode()).HALF_UP) )
${integerFormat.format($number.toNumber($lead.YourField))}

(Assuming of course you meant arithmetic rounding.)

Translate

K

KainelsonAuthor

Level 2

This is great, thank you. If you don't mind can you telling me how I would incorporate my custom object field in this? I am receiving the number through a custom object field and need my token to round the integer and display in my email. Thank you!

Translate

SanfordWhiteman

Level 10

Well, a person can have multiple CO records. Do you want to output this single field (rounded) for each CO record?

Translate

Sign up

Login with SSO

Login to the community

Login with SSO