Hello,
Summary I am creating a transaction history table with a amount column.
The Table
- Column 1 = “Transaction Type’ The format is a “Rowlist and Picklist”. The choice are Withdraw, Deposit, Ajustement etc.
- Column 2 = “Amount” the format Currency.
- Column 3 = “Value” the format is a Currency with the formula.
The objective When transaction type is “Withdraw” then “Amount” is multiplied by -1, or no change.
The Formula for Column Value:
=IF([Type]=“Withdraw”, [Amount]*-1,[Amount])
The issue I have a #Error
Help