How can I make a FLOAT type field in a SuiteAnalytics workbook data set display more than 2 decimal places?

AI generated answer (using internal Slack threads):

To make a FLOAT type field in a SuiteAnalytics workbook data set display more than 2 decimal places, you can use the

TO_CHAR

function in a formula field. This function allows you to convert a number to a string and specify the format of the output. Here is an example of how you can use it:

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

In this example,

{field}

is the name of the field you want to format. The string

'999,999.999'

specifies the format of the output. The number of 9's after the decimal point determines the number of decimal places. In this case, there are three 9's after the decimal point, so the output will have three decimal places. Please note that this will convert the field to a string, so it may not be suitable for all use cases. If you need to perform calculations with the field, you may need to convert it back to a number. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******