Equation Question

  • Resolved stuartlloyd

    (@stuartlloyd)


    3 years, 8 months ago

    Hello, I would like to know how to make a field appear when a particular value is = to or greater than or less than.

    Basically I need a product (5.4kW) recommendation to appear when the outcome value is between 3.6 to 5.4

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author codepeople

    (@codepeople)

    3 years, 8 months ago

    Hello @stuartlloyd

    Thank you very much for using our plugin. In the calculated field settings, click on the “Edit rule manually” link, enter the validation rule manually 3.6 <=value && value<=5.4 and select the dependent field:

    Best regards.

    Thread Starter stuartlloyd

    (@stuartlloyd)

    3 years, 8 months ago

    Thank you so much.

    This helped me a lot.

    Have a good day further.

    Thread Starter stuartlloyd

    (@stuartlloyd)

    3 years, 8 months ago

    Hi @codepeople

    I have another question. In the calculations how can I limit the amount of digits in a value.

    Say my value is 9.674399999999999 how can I make it display say 9.67?

    Many Thanks

    Plugin Author codepeople

    (@codepeople)

    3 years, 8 months ago

    Hello @stuartlloyd,

    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 two decimal places, you should edit the equation as follows: PREC(fieldname1*fieldname2, 2)

    More information about rounding operations by reading the following post in the plugin’s blog:

    https://cff.dwbooster.com/blog/2020/09/20/rounding-numbers

    Best regards.

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

The topic ‘Equation Question’ is closed to new replies.