Hi patrice, thank you for your answer. The formula is correct as it should

yield 133 not 233. The formula is part of bidding program an is attempting

to mark up items by percentage. I always thought that you would, in the case

of 25 percent, just take 25 percent of total and add it, however this is not

correct. To achieve a true markup I must use the formula supplied. (Old

formula was in program and is not making estimators happy, new formula was

mandated). Somehow this calculation is not being achieved, I have tried

casting the types within the formula to differing values thinking it might be

some type of decimal overflow, but to nought. I would appreciate any

feedback.

Thanks

Howard

"Patrice" wrote:

> The result is correct so as this is not what you want, the formula you want

> to use is just wrong.

>

> You could start from the correct formula and transform it into the form you

> want (could it be a confusion between a formula that would take a part of

> the whole percentage (25%) against another formula that would use the other

> part of the percentage (75 %)) ???

>

> --

> Patrice

>

>

> "hfarner" <(E-Mail Removed)> a Ã©crit dans le message de

> groupe de discussion : (E-Mail Removed)...

> > Hi,

> >

> > I have a rather complex dataset where there error occurrs, but I created a

> > small project and can reproduce the error. Here it is in a nutshell:

> >

> > Datatable Bid has columns PCT decimal and ID, also TotalBid and TotalCost

> > expression columns.

> >

> > Table BidChild has column ID relating to parent Bid, Quantity and price,

> > decimal. Cost is the expression Quantity*Cost as decimal, BidCost is the

> > following formula:

> >

> > Cost + (Cost / (1-Parent.PCT))

> >

> > In theory, this would show the marked up cost based on the value of the

> > PCT

> > field in parent record. So, put two grids on a form showing the data and

> > place .25 in the PCT column, add a child putting 1 in quantity, 100 in

> > price

> > and the calculation yields 233.333333333333 (Not the correct answer).

> > However, if you change the formula to Cost + (Cost * Parent.PCT) it yield

> > a

> > correct answer. I need the formula as shown above, not the one that

> > actually

> > yeilds a value. Can someone please tell me either a) what I am doing

> > wrong

> > or b) suggestion on corrective action to get the correct value.

> >

> > Thanks!

> > Howard Arner

> >

>

>