S-Docs Tips: Negative Currency

Posted in

Scenario:

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?

 

Solution:

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

 

 

Get in touch today to see how WDCi can help your business.