7 Replies Latest reply on Mar 24, 2014 4:04 PM by philmodjunk

# Need help for a calculation for a late fee.

### Title

Need help for a calculation for a late fee.

### Post

I need help for a calculation. In our school if a student pays their tuition fee past 10 days of the month they would be charged for a late fee of, lets say 5%.

Lets say if i input the amount \$40.00 and the database detects that it has been past 10 days of the month then there would be a 5% charge to the amount.

Is there a calculation/formula for this?

• ###### 1. Re: Need help for a calculation for a late fee.

Please explain what you mean by "past 10 days of the month".

Does this mean that if payment for April is received after May 10th, there is a late fee? Or  if it is received after April 10th there is a late fee or ???

• ###### 2. Re: Need help for a calculation for a late fee.

If payment is received after the first ten days of the month. Lets say payment for April, after April 10th then there will be a late fee.

• ###### 3. Re: Need help for a calculation for a late fee.

I would think a late fee would be 10 days past the due date.  Your screenshot shows only a date of 3/20/2014.  This doesn't state if this is the due date or the date the record was made.

• ###### 4. Re: Need help for a calculation for a late fee.

No this was just a sample database that we were testing on. So lets base this screenshot as an example. It shows the date of 3/20/2014 so therefore the student is past the due date and will be charged for the late fee. In order for the student not to be charged for the late fee they need to pay before the 11th of April.

• ###### 5. Re: Need help for a calculation for a late fee.

Define LateFee with an auto-enter calculation:

If ( DateReceived - DueDate > 10 ; 10 )

To record a \$10.00 late field in the late fee field. DateReceived and DueDate would be date fields of type date.

• ###### 6. Re: Need help for a calculation for a late fee.

Hey Phil,

Do i have to create a due date field and input the due date manually to get this to work?

• ###### 7. Re: Need help for a calculation for a late fee.

Somehow, you have to provide the due date. It can be an auto-enter calculation, however, if you can figure out a way to compute that date from the current date either when you create the record or when you update it to record the payment. I haven't tried to specify those details as it depends on how you plan to work with your data base.