I want to show the amount in a thousand separator format. I have done it using TO_CHAR but it is limiting me to SUM
two column values. For example below query works fine without thousand separator but gives error otherwise
"could not be evaluated because of error ORA-01722: invalid number"
to_char(sum(unapplied_amount * nvl(a.EXCHANGE_RATE,1)),'999,999,999.99') +
to_char(sum(on_Account * nvl(a.EXCHANGE_RATE,1)),'999,999,999.99')
from XX_SF_COLLECTION_V a
where a.CUSTOMER_SITE_USE_ID = :order.invoice_to_org_id)
Could anybody suggest a solution