Formatting Negative Currency Amounts

By default, currency with a negative amout will appear in parenthesis.  $(54.00)  This may not be desirable on your printed output. 

 

This may be changed assuming the following:

1. The data appears as "-54.00" in the input.

2. The amount is stored in a currency field/variable and is being mapped with a "%m" format string

 

 

This is what you will need to do to change the formatting:

1. Change the variable type from "currency" to "real" in the definition.

2. Change the format string in the mapping from "%m" to "$%.2n"

 

Your printed output should now appear as "$-54.00"

0 Comments

Article is closed for comments.
Powered by Zendesk