What I've been trying to get down seems simple but isn't really simple for me.
I'm trying to create a receipt form, so my table consists of Transaction, Product, Amount, Rate, Subtotal. The objects I'm using are a drop down list, drop down list, numeric field, decimal field, numeric field.
What I am trying to accomplish is in my Transaction drop down menu the options are buy or sell. I want if someone selects buy that the amount field, whatever is filled in is a negative number so as to calculate a proper subtotal and total.
I really need some help with this cause I've been trying to figure this out for days.