Format number on calculated field


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
3 Answer(s)


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



Intermediate Answered on August 31, 2020.
Add Comment
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.

Intermediate Answered on August 31, 2020.
Add Comment

You can use validade field to limit the decimal number,

Rookie Answered on September 1, 2020.
Add Comment

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