Nov 19, 2009; 05:44
George R. Hozendorf
Calculation by month or quarter
I'm stumped and about to change direction all together, but don't want to. I've got a dollar amount field and want to get a result showing how much the payments to pay it off would be if it's done monthly, quarterly, semi-annually or annually. This would be very simple if the payment schedule showed 12, 4, 6 or 1, but I have a drop down menu for the schedule in text format. Thus, the fields are Due (numeric), Payment Schedule (drop down of Monthly, Quarterly, Semi-Annually and Annually), and Payment (calculation of Due divided by results of Payment Schedule. I would also like to be able to have the Date Due fill in automatically based on the Payment Result i.e. Quarterly produces 1/1/09, 4/1/09, etc.
I've thought about using a mask on the Payment Schedule, but that seems like over kill.
Any suggestions?
George
10 Advanced
--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/
Nov 19, 2009; 07:06
Colin MacGregor
Re: Calculation by month or quarter