Rounded???

  • Resolved bommelmann

    (@bommelmann)


    2 years, 7 months ago

    Hello, I’m trying a very simple solution, but I can’t find it. I would like to calculate 89.023sqm – 88.018sqm and the result should be rounded to three decimal places. But my result is 1.0049999999999955sqm and not 1.005sqm.

    I also tried the following form: Round((fieldname3-fieldname2), 3). but that didn’t work either. Can you help me? Thanks and kind regards, Markus

Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    2 years, 7 months ago

    Hello @bommelmann

    Thank you very much for using our plugin.

    Please use the PREC operation as the outermost operation in the equation.
    PREC(X, Y) rounds the number X with Y decimals.

    For example, if you have the equation fieldname1*fieldname2, and you want the result with three decimals or no decimals if the result is an integer number, you can edit the equation as follows:

    PREC(fieldname1*fieldname2, 3, true)

    Best regards.

Viewing 1 replies (of 1 total)

The topic ‘Rounded???’ is closed to new replies.