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.

Under construction. Email me your wish list for improvements.