PmtBreakdown ( Cost ; QtyPmts ; PmtAmt ; AddFinalPmtToLastPmt )

Gives a payment breakdown summary

Average rating: 4.5 (31 votes) Log in to vote

Don Wieland - Show more from this author
DW Data Concepts
http://dwdataconcepts.com

Sample input:

PmtBreakdown ( 1000 ; 7 ; "" ; 1 )

Sample output:

6 monthly payment(s) of $142 and
one final payment of $148

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

Let([

C=Cost;
rMP=QtyPmts;
rMA=PmtAmt;
ATL=AddFinalPmtToLastPmt;
cMP=Truncate ( C / rMA ; 0 );
cMA=Truncate ( C / rMP ; 0 );
cFP= Case(not IsEmpty(rMP) ;  C - (cMA * rMP) ; C - (rMA * cMP));
BD=
Case(
IsEmpty ( rMP ) and IsEmpty ( rMA ); "Enter the Number of Months or Monthly Amount";
C = 0; "There is no Cost for this option";
If( cFP  = 0; 
If(IsEmpty ( rMP ); cMP  & " monthly payment(s) of $"  & rMA; rMP  & " monthly payment(s) of $"  & cMA);
If(IsEmpty ( rMP ); If(ATL; (cMP - 1);  cMP)  & " monthly payment(s) of $"  & rMA & " and ¶one final payment of $"  & If(ATL; (cFP  +  rMA);  cFP); 
If(ATL; (rMP - 1);  rMP)  & " monthly payment(s) of $"  & cMA & " and ¶one final payment of $"  & If(ATL; (cFP  +  cMA);  cFP)

)))


]
;

BD)

Gives a payment breakdown summary based on either the "Quantity of Payments" or "A desired Payment Amount".

There is also a PARAMETER to "Add Final Payment to Last Payment" - set it "1" to add it to the last or "NULL" to not. I used a check box (value list = 1) to toggle this option.

If both the QtyPmts and PmtAmt have values in them, the result will be based on the QtyPmts value.

Comments

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

PmtBreakdown ( Cost ; QtyPmts ; PmtAmt ; AddFinalPmtToLastPmt )

Comments

Support this website.

Support this website.