function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Formatting a custom field with and without Decimal Places showing

Hi -

I need to cretae a custom field to hold a Dollar amount.  It's for a donation letter for a Non-Profit where most of the amounts are whole dollars.  But some do have decimals.

They want the Conga Letter to print as





For the bulk of the donations, with no Decimals ($20, $100), they just want to print the amount.  But for those with decimals, they want to print the decimals ($106.87).


Is there a way to use a formula field or something in SF so I can put that in my Conga Template to print as they wish?




You could create a custom formula to return a clean dolloar amount in text.

if(mod( Donation__c ,1)>0, text(Donation__c), substitute(text(Donation__c),'.00',''))

This return a text value so you will need to use some conga merge magic.

When rendering in excel i know you can define fields for merging as numeric and you can also define appearance through parameters. Not sure how word handles the fields.


take a look at: