CASE WHEN {total} = 0 THEN ‘ZERO ONLY’ WHEN {total} < 1 THEN (CASE WHEN ROUND({total} * 100, 0) > 0 THEN TO_CHAR(TO_DATE(ROUND({total} * 100, 0), ‘J’), ‘JSP’) || CASE WHEN {currencyname} = ‘Indian Rupee’ THEN ‘ PAISE ONLY’ WHEN {currencyname} = ‘US Dollar’ THEN ‘ CENTS ONLY’ ELSE ” END ELSE ” END)… Continue reading Formula to display total amount in words which handles both Dollars and Rupees
Tag: currency_formula
Formulas for Sales achieved, Gross profit and Overdue/Collection percentages for sales commission calculation
Sales achieved % = (actual Sales / Target sales ) *100 for an associate for a specific month Gross Profit % = (Sales – COGS) / Sales *100 Overdue %= Overdue Invoices amount / Total Open invoices amount *100 : There will be open invoices with no overdue. Such invoices wont be considered for numerator.
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