Home

Format number on calculated field

Answered

I have a custom record with a calculated field.  This number is showing up on the form with way to many digits to the right of the decimal point.  How can I format it to just show 2?

Beginner Asked on August 31, 2020 in Administration.
Add Comment
Cancel
3 Answer(s)

Hi,

What type have you selected for the field? You probably want “Currency” in this instance.

Thanks,

Chris

Cancel
Intermediate Answered on August 31, 2020.
Add Comment
Cancel
Best answer

Making it a currency field will limit it to two decimals. However, you might need to use a Round() function.   Not sure  how you created the field but thought this might help.

Cancel
Intermediate Answered on August 31, 2020.
Add Comment
Cancel

You can use validade field to limit the decimal number,

Cancel
Rookie Answered on September 1, 2020.
Add Comment
Cancel

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor