This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

image.png

I have a custom field with a formula, it is working but showing all the decimal places from the calculations. Can I edit it to only show 2 decimals and round up or down ?

ROUND should work.
<https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ROUND-number.html>

thank you <@U03DF9QL7FX> that was going to be my next question, I am very new to this lol

that is only going to round the custom field and not the fields in the formula correct?

Correct. Is your formula populating correctly?

gotta check but wanted to ask before I bombed anything lol. I will try it out on the sandbox first and come back with an answer