Calculation needing to show negative figures

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

OTWarrior - 30 Apr 2007 10:50 GMT

I have (complicated) series of calculation boxes which draw their data from
text form fields and drop down form fields, and the final resulting
calculation is the overall cost.
eg:

(text1 * dropdown1) = calc1

calc2 = (calc1 * text2)

calc1 is the hours result, calc2 is the cost result.
calc2 is actually made using the autosun button, and changing the formula
(otherwise it gets confused with calculating using another calculation)

I have a situation where the figure can be a negative (hours off for
example) which shows this figure fine. (-5 hours). the problem lies with the
cost which shows the figure in a different format [exact example below].

(£50.00)

whereas it should show
£-50.00
or
-£50.00

How do I change this (if possible)?

Reply to this Message

Stefan Blom - 30 Apr 2007 11:34 GMT

To the field code, add a numeric picture switch to specify the format of
positive, negative, and zero results, respectively. For example:

\# "£#;£-#;0"

The code means: for positive results, display currency symbol and then
the number (or a space); for negative, display currency symbol, minus
sign, and number; for zero results, display only a zero.

Signature

Stefan Blom
Microsoft Word MVP

> I have (complicated) series of calculation boxes which draw their data from
> text form fields and drop down form fields, and the final resulting
[quoted text clipped - 21 lines]
>
> How do I change this (if possible)?

Reply to this Message

Rate this thread: