Saved Search formula to display the currency value with a dollar sign, comma separation, and decimal points.

Attached the saved search formula

Formula Currency:

CASE WHEN {custrecordjj_quota_achived} IS NOT NULL AND TO_NUMBER({custrecordjj_quota_achived}) != 0 THEN  ‘$’ || TO_CHAR(TO_NUMBER({custrecordjj_quota_achived}), ‘FM999,999,999.00’) ELSE ‘$0’ END

Leave a comment

Your email address will not be published. Required fields are marked *