How to calculate power

  • Resolved drcook

    (@drcook)


    3 years, 2 months ago

    Hi there, I am trying to calculate the following expression but I get an error.
    What is the correct way to use power ?

    IF(fieldname2<=2, fieldname2^(3/4)*70, IF(AND(2<fieldname1, fieldname2<45), 30*fieldname2+70, fieldname2^(3/4)*70))

    Thanks in advance,

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

    (@codepeople)

    Hello @drcook

    Thank you very much for using our plugin. Javascript does not include the operator ^, for this reason, our plugin includes the POW operation.

    x^y is equivalent to POW(x,y)

    So, your equation can be implemented as follows:

    IF(fieldname2<=2, POW(fieldname2,3/4)*70, IF(AND(2<fieldname1, fieldname2<45), 30*fieldname2+70, POW(fieldname2,3/4)*70))

    Best regards.

    Thread Starter drcook

    (@drcook)

    Great, Thank sooo much !!
    What a great support !

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘How to calculate power’ is closed to new replies.