Friday, February 22, 2019

Remove Decimal Place in the Amount in a Transaction Saved Search Using a Formula

1. Navigate to Reports > Saved Searches > All Saved Searches > New.

2. Click on Transaction.

3. On the Results tab > add  Formula Text > Formula: TO_CHAR({amount},'9,999,999')

4. Save & Run.

No comments:

Post a Comment