how to convert this number: Round(Avg(case when {time.custcolcust_submission_date} >={time.custcol_eq_date_submitted_new} then 100.00 else 0.00 end),2) to string in NetSuite saved search

AI generated answer (using internal Slack threads):

In NetSuite saved search, you can convert a number to a string using the

TO_CHAR

function. However, the formula you provided seems to be a calculation that results in a number. If you want to convert this number to a string, you can wrap the entire formula with the

TO_CHAR

function. Here is how you can do it:

TO_CHAR(Round(Avg(case when {time.custcolcust_submission_date} >= {time.custcol_eq_date_submitted_new} then 100.00 else 0.00 end),2))

This will convert the result of your calculation to a string. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******