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.
No comments:
Post a Comment