Newbie looking for help with late fee calc

[Bill_n_miami]

Hello everyone and thank you for your time in making this forum possible.

Can anyone tell me how to prevent a negative number from returning when I multiply a field by .06?

I created my own billing system and am having trouble with the late fee calculation. If someone has a late payment or even has paid on time there is no problem as the late fee calc is either 0 or the proper late fee. The problem arises when there is a credit balance.The expression simply multiplies the balance due by .06 and creates a negative late fee which when added to the list of current charges reduces the total due.

Here is the expression: Late Fee: ([Prev Bal]-[Paymt Recv])*0.06
I would like to use an expression that would only return a positive value when called for or a zero if there is no late fee or a negative fee.

Any help would be immensely appreciated.
Thanks,
Bill

 

[pbaldy]

This type of thing:

Late Fee: IIf([Prev Bal]-[Paymt Recv] > 0, ([Prev Bal]-[Paymt Recv])*0.06, 0)

The spaces in your names are not worth the bother in the long run.

 

[Bill_n_miami]

Paul,

Thank you very much for this information. Your generosity has made my life so much easier.

 

[pbaldy]

Happy to help, and welcome to the site!