Help with if statement in report

[Nixx1401]

I have a report which is generated from a query. The report displays the individual name and the currency amount that person possess.



These are the fields: Transaction Number, Transaction Date, Name, ID, Amount Withdrawn, Amount Deposited and the currency is grouped. This formula here calculates the currency balance
=Sum([curDepositAmt])-Sum([curWithdrawAmt]) but if the withdrawn amount is blank it return no value for the currency balance

Can someone assist me with the formula. This is what is came up with but I am getting an error

=iif([WithdrawnAmt]="Is Null" =Sum([curDepositAmt], =Sum([curDepositAmt]- =Sum(curWithdrawnAmt])

If the withdrawn amount is blank display the deposit amount if not subtract the sum of deposits from sum of withdrawals

[NoellaG]

Hi,

try the NZ function: this function replaces the null value with the value you give in the second argument

=Sum([curDepositAmt])-Sum(NZ([curWithdrawAmt],0))

greetings
NG