I want to create a filed giving the statuses of balances in another field. My if statement givers me only 2 options?
If ( current_month_bal < 0 ; "Overspent" ; "Zero or in Surplus" )
But I would like 3 options:
2. In Surplus
3. Zero Balance
Any suggestions would be most welcome. FM Pro 16