Hello,

I am new to Filemaker Pro and need help.  I use prorata calculations for my payments.

Here goes:

Our month runs from the 26th of the month to the 25th of the following month. (That is a full month without the Sundays - 26 days)

If our clients contract starts on the 30th and the cut off is the 25th he will receive a prorata payment for the first month.

It would have to be the full monthly amount divided by 26 days times the prorata days equals the prorata amount

How do I get the calculation right for my field and how would I enter it there?

Can anyone help me?

Thank you in advance.

Patricia

I'm not sure what your issue is -- you just stated the calculation yourself:

( full monthly amount / 26 ) * prorata days

You could define this as a calculated field, or a number field with an auto-enter calculation, or you could use a Set Field script step attached to a button. You'll probably want to use the Round function as well. Does any of that help?

Welcome to the forums!