Format the Value of Projected Total to Include Commas on the Results of a Saved Search

To format the value of the Projected Total as comma style, follow the solution below:

 

1.      Create a saved transaction search, List > Search > Saved Searches > New > Transaction.

2.      Navigate to the results tab.

3.      Add Formula (Text) and enter the formula:

to_char({projectedamount},'999,999.99')

4.      Change the Custom Label to Projected Total

5.      Change the Sort by to Formula (Text)

6.      Save and Run the report.