formula field – knowledgebase JJ

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

Formula(HTML) progress bar

First test: On my first test, I’ve replicated your concern with simpler values: ‘<progress style=”accent-color:red;” value=”‘||55-5||’” max=”100″></progress>’ Results: Which is to be expected based on your concern. Second Test: I followed your advise wherein if I change the arithmethic symbol to * or /: ‘<progress style=”accent-color:red;” value=”‘||10*5||’” max=”100″></progress>’ Results: With this, it shows the correct progress bar as… Continue reading Formula(HTML) progress bar