Outstanding Amount

[Kishan_Canoo]

I have 3 fields and the first field is Amount the second field is Deposit and the third field is Balance.

Generally my calculation should be Balance = Amount - Deposit

If i insert the Amount, example $100 and the Balance automatically changed to $100.

I need the Balance remain empty unless i insert a number in the Deposit Field.

In my outstanding due report, if their is no Deposit, the Balance field should remain empty.

Any help.

[comment]

Try =

If ( Deposit ; Amount - Deposit )

 

[Kishan_Canoo]

comment you are the best

Your solution worked fine.

Thanks a lot.