Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
saraAsaraA 

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

$20

OR

$566.23

 

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?


thanks!

Sara

Kool_RudKool_Rud

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.

&=ReportData.Donation__c(Numeric)

take a look at:

http://knowledge.appextremes.com/appextremes/ext/kb33-formatting-number-values-in-conga-word