4 Replies Latest reply on Aug 17, 2011 9:47 AM by ErikChristman

    Not calculating most records

    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