Monday, October 29, 2018

Modify the number (9999.9999) Format to 9,999 in a Transaction Saved Search Using a Formula

When using Formula (Numeric), calculated results are displayed like 9999.99999. To format numeric results with comma separators like 9,999, use Formula (Text) = to_char(({total}*1.1),'$99,999,999.99')

No comments:

Post a Comment