AnsweredAssumed Answered


Question asked by GaryBunney on Aug 7, 2012
Latest reply on Aug 7, 2012 by philmodjunk




I have been using FMP for a few years now, but have used it for just tracking orders for our engineering group. So basically all my experience has been inputting data.

I have created a new database that requires some calculations and not sure how to formulate them.

My first calculation is an IF statement.  I want to subtract one field from a second and if the number is negative I want it to replace the negative number with a 0. 

The second calculation is an IF statement that would add a set fee to a number if it has not been paid in one year, but it will also need to add an additional fee for every year it goes beyond that.  Example is $50 was due by April 1, 2009 and as of August 1, 2012 the amount has not been paid.  The balance now due would now be $50 plus a $5 late fee for 2009, 2010, 2011 and 2012.

Any help would be greatly appreciated.