Hi and sorry if this is a basic question.
I wish to track the purchase and sale of shares. I want the cash account to add the transaction amount if it is a SELL of shares, and to subtract the transaction amount if it is a BUY.
I was thinking of an 'OnObjectExit' script trigger in the 'Total Amount' object which goes something like this;
If (Action = "Buy" ????? Not sure what to put after this???
'Action' is the name of the BUY/SELL field.
'Total Amount' is the name of the transaction amount.
'Account' is the name of the ongoing account balance.
Any assistance would be appreciated.