FORMULAS - NEGATIVE RESULT

[Jannae72]

Working with formulas, if the amount is negative I would like it to automatically show the amount as (-20) rather than just -20.  Can you please advise me what I need to do.

Regards

Jenny

[Paul_Butenko]

Hi,

You can do it with script:

$.rawValue = concat("(" , NumericField1.rawValue , ")"), field which shows this value should be TextField.

Also you can use patterns, for youre case use num{( -zzzz)}.

BR,

Paul Butenko

[Jannae72]

I tried the pattern but that didn't work.  If the formula resulted in a negative number i.e. -88 it gave me (-88) but if the formula resulted in a positive number i.e. 88 it would still give me -88. 

Jen

[_Bruce_Robertson · Accepted solution]

Hi Jen,

The display pattern you need is num{(szzzz)}

The "s" is the symbol to display the minus sign.  Any symbols that don't have a special meaning are displayed as themselves (like the "-").

The complete list is defined in http://partners.adobe.com/public/developer/en/xml/picture_clause_2.0.pdf

Regards

Bruce

[Jannae72]

Thanks Bruce!