Brian Dunning's FileMaker Custom Functions

PaymentCalculator ( Amount ; NumberOfPayments )

Returns a return-delimited list of payment amounts rounded to the nearest penny. The remainder of the division is evenly distributed a penny at a time among the first payments.

  Average rating: 4.4 (37 votes) Log in to vote

Kevin Bache   Kevin Bache
None
www.none.com

Share on Facebook Share on Twitter

  Sample input:
PaymentCalculator ( 1000 ; 6 )
  Sample output:
166.67¶
166.67¶
166.67¶
166.67¶
166.66¶
166.66¶

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Divides Amount by NumberOfPayments, rounding to .01.

Distributing remainder evenly among the first payments .01 at a time so that all payments are as even as possible.

Contains a trailing "¶". Inputs can be numbers formatted as text or numbers.

Maximum of 9999 payments, at least on my computer which has 512MB of RAM.

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: