I just can't get my head around recursive functions. I need to write a recursive function to find out an amount.

Base Bid = prime cost + Builders risk Insurance Amount

Builders Risk Insurance amount = Base Bid/100 x 0.10.

no matter what custom function I write, I get a "?" It is driving me crazy. I can do this all day long in excel by enabling iterative calculations and writing a circular reference formula. But in FM13 I am stumped.......

It depends on how the contract fees are supposed to be applied, but if the terms are the same as the original, then add them all together to get your fee.percent for the above calculation. Say, you have three fees of 0.1%, 0.5%, and 0.15%. Then

Let ( [

x = TTLPrimeCost ;

y = .001 + .005 + .0015 ;

z = ( x * y ) / ( 1 - y ) ;

total = x + z

];

total

)

Once you have the total, you simply multiple that by the particular fee.percent to get the fee.