Precalculated Field

Hi,

What are the values of fields: fieldname2 and fieldname3? The PREC(x,y) operation is similar to ROUND(x), but rounding a float number with the decimal digits passed as the second parameter. So, if the mathematical operation fieldname2*fieldname3/100*0.0393701 is a very small number, the rounding process will return the same result. For example, all following numbers would be rounded to -2.25:

-2.245678
-2.247658
-2.248573
-2.251234
…

Best regards.

Sorry, I was not clear enough.

fieldname2*fieldname3 are Numer fields, without predefined values. An example of values that will be used for these fields are 245 and 45, respectively.

Even is I take out prec() and simplify, the form is still not behaving the way I expect it to.

I stripped down the formula to this: fieldname2*fieldname3/100*3-2. When form is displayed on the page, the calculated value is -2 by default. Once I enter the values into other fields, it does the calculation as expected.

Thank you!

Here is the screenshot: https://imgur.com/myWVnTB

Hi,

Your current equation is:

prec(fieldname2*fieldname3/100*0.0393701-2.25,2)

if fieldname2 = 245 and fieldname3 = 45, the evaluation would be:

PREC(245*45/100*0.0393701-2.25,2) =
PREC(110.25*0.0393701-2.25,2) =
PREC(4.340553525-2.25,2) =
PREC(2.090553525,2) =
2.09

I’ve checked the result in my copy of the plugin and it is working fine.

By default you are receiving a value in the calculated field, before entering the values of fields: fieldname2, and fieldname3, because the empty fields are considered as zero.

If you don’t want to evaluate the equation if the values of fieldname2, and fieldname3 are empty, you should to use conditional statements in the equation:

IF( AND( fieldname2, fieldname3), PREC(fieldname2*fieldname3/100*0.0393701-2.25,2), '' )

Best regards.

Excellent, I was thinking about IF statement. Thanks a LOT for your help!