S-Docs Tips: Negative Currency


Creating S doc templates and pulls out value with negative number. ie: -400.

When we pull out number fields, S Doc will define number format, ie: {{!Opportunity.amount #,###.##}}. Using this format will return value in a form of 1,234.00 But if the value is in negative form, it will return as (1,234.00).


So how do we make S Doc show the negative sign?



1) Create a custom NUMBER formula field.

2) Copy value of the field to display. ie: UnitPrice

3) Pull out the text formula in S Doc template.


This method is applicable to both positive and negative value. 


negative value formula