how do I make a numeric amount field to text so that I can group it

AI generated answer (using internal Slack threads):

To convert a numeric amount field to text so that you can group it in a saved search, you can use the

TO_CHAR()

function in a formula text field. Here is how you can do it: 1. Create a new formula text field in your saved search. 2. In the formula text field, use the

TO_CHAR()

function and pass the numeric field as an argument. For example, if your numeric field is

amount

, your formula would be

TO_CHAR({amount})

. Please note that this will convert the numeric field to a text field, allowing you to group by this field in your saved search. However, if you encounter an error message like "The result field Formula (Text) cannot be grouped. Please edit the search and omit this field or use a different summary function.", you might need to find a different way to group your data. If you need to convert a free-form text field into a number for calculations in a saved search, you can use the

TO_NUMBER()

function in a similar way. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******