AnsweredAssumed Answered

Not calculating most records

Question asked by ErikChristman on Aug 17, 2011
Latest reply on Aug 17, 2011 by ErikChristman

Title

Not calculating most records

Post

I am new to FM, so this might be a really simple problem, but I cannot figure it out.  I have created a calculation field called "Margin."  It has the calculation (SellingPrice - Cost) / SellingPrice.  On maybe 10% of my records, it returns a proper value, but on all others is displays "?".  Any thoughts?  In all the records the SellingPrice is greater than the Cost and both fields have values.

Thanks,
Erik

Outcomes