I have a DB with a number of fields, 2 of which are as follows:
in_out (text - dropdown lis - In or Out)
I would like to change the amount field to display a number surrounded by parentheses (negative) based on the content of the in_out field.
Example: The transaction is for $2000.00 and it is an outgoing wire transfer. The user chooses "out" from the in_out dropdown list, the amount displayed in the amount field would display as ($2000.00). If however, the users chooses "In", the amount field would simply display $2000.00.
Can anyone tell me what calcualtions I need to do on what fields to get this to work?
Thank you for your help