AnsweredAssumed Answered

Change one field based on another field's content

Question asked by bobrace on Mar 14, 2014
Latest reply on Mar 14, 2014 by raphthepenguin

I have a DB with a number of fields, 2 of which are as follows:

 

in_out (text - dropdown lis - In or Out)

amount (numeric)

 

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

 

Bob Racinowski

Outcomes