I have a custom field that uses a formula and gives a number in the field. How can I change it to only show 2 decimal places instead of all of them

AI generated answer (using internal Slack threads):

In NetSuite, if you want to display a number with two decimal places in a custom field that uses a formula, you can use the

TO_CHAR

function in your formula. This function converts a number to a string in the format you specify. Here's an example of how you can use it:

TO_CHAR({field},'999,999.99')

This will convert the field value to a string and format it to have two decimal places. If you're using this field in an email template, you can use the Freemarker syntax to format the number. Here's an example:

<#assign myNumber = record.field?number>
${myNumber?string["0.00"]}

This will assign the field value to a variable

myNumber

and then format it to have two decimal places when it's displayed in the email. Please note that these methods will only affect the display of the number, not the actual value stored in the field. If you need to maintain the full precision of the number for calculations, you should keep the original field value and use these methods only for display purposes. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******