In saved search formulas how can I force a currenc...
# administrationg
GMR Admin
09/05/2025, 8:46 PMIn saved search formulas how can I force a currency field to display in the format 9999.99 with no currency symbol and always two decimal places even when it's 0.00?
m
MGBC
09/05/2025, 8:47 PMROUND({field},2)
MGBC
09/05/2025, 8:47 PMFormula numeric
g
GMR Admin
09/05/2025, 8:48 PMdid that, still comes through as an integer
GMR Admin
09/05/2025, 8:48 PMit drops trailing zeros
m
MGBC
09/05/2025, 8:49 PMMaybe RPAD?
g
GMR Admin
09/05/2025, 9:07 PMChatGPT found the answer
TO_CHAR(TO_NUMBER(REPLACE({amount}, ',', '')), 'FM9999999990.00')GMR Admin
09/05/2025, 9:08 PMRPAD kinda worked but it left out the decimal
13 Views