Avatar

Level 6

Your requirement ("-$18,970.50") is not so common and may have to do major changes to meet this....I will start using a textField rather than a NumberField and Format using scripting not using out of box functionality. Changing text color to red is easy and can be easily done using scripting again.

I am sure you can try your self if you have some idea about JS or FC scripting....I can help you if you post additional requirements.....like...

1. Is the value prefilled / keyed in / calculated from other fields or combination of one or more?

2. Max and Min value allowed/ expected.

3. Any involvement of user actions there on?