I am attempting to display dollar amounts with an icon next to them in order to indicate if they are over/below a certain dollar amount.
So far the closest I can come to accomplishing this is a formula such as :
IF(currencyfield__c < currencyfield2__c,
Text(currencyfield__c) & IMAGE('/servlet/servlet.FileDownload?file=015550000000fff, Name) ,
Text(currencyfield__c))
But unfortunately since this will display the currencyfield__c as text no commas will appear in the currency to properly display thousands.
And apparently I can't solve this by making the formula field a currency field because then it won't properly display the image.
Any ideas ?