Simple adding fields equation produces incorrect results

  • Resolved apekhtin

    (@apekhtin)


    12 years, 7 months ago

    Hello,

    i have total field in the form here ,

    it just adds calculated fields above it “fieldname1+fieldname2+…” .

    The problem is that if a number greater that 454 is inserted into the “Gross tonnage” field, the sum of the calculations in the “Total” becomes incorrect and weird. Adding together numbers as big as several thousands returns a total of two digit value. All calculated fields use prec function, but the result is the same if prec is removed.

    The funny thing is that all other fields with much more complex calculations always return correct values.

    Looking forward to any ideas on this weird behaviour.

    Thanks

    http://ww.wp.xz.cn/plugins/calculated-fields-form/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter apekhtin

    (@apekhtin)

    12 years, 7 months ago

    Didn’t get an answer from you so i just made a giant formula in the total field, that includes the formulas form all the other calculated fields and it works ok.

    Plugin Author codepeople

    (@codepeople)

    12 years, 7 months ago

    Hi,

    I’m sorry, I couldn’t read your entry previously; but I saw you’ve solved the issue by yourself, congratulations. And one more time, my apologize by delay.

    rickhultz

    (@rickhultz)

    12 years, 1 month ago

    I have the same issue. I have a Total calculated field that has other calculated fields in its formula. I have all the calculated fields prec function to one decimal. The Total calculation isn’t correct based on the other calculated fields. It appears there is a rounding issue with the calculated fields.

    Can you help?

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Simple adding fields equation produces incorrect results’ is closed to new replies.