Formula Help

  • Resolved WebSam

    (@snice)


    4 years, 7 months ago

    Hiya, thanks for the great plugin. I’m trying to implement a formula into my website that looks like this:

    (((14.2/(1+7.3*2^(-(FIELD DATA)/96)))^3+((FIELD DATA)/51)^2.91)-8)*0.993

    I know the ^ symbol isn’t supported, and I need to use POW but I can’t get it to work, I’ve looked all over the place, and I think I’m missing some brackets maybe? Math’s isn’t my strongest, any help would be appreciated.

    Thanks.

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

    (@codepeople)

    Hello @snice

    Assuming the “FIELD DATA” corresponds to the fieldname1, the equation would be:

    
(POW(14.2/(1+7.3*POW(2,-1*fieldname1/96)),3)+POW(fieldname1/51, 2.91)-8)*0.993

    Best regards.

    Thread Starter WebSam

    (@snice)

    Awesome, thank you so much for the help and quick reply.

    Thread Starter WebSam

    (@snice)

    Another question, how would I get the answer to 2 decimal places, I think I need to use the PREC operator somewhere.

    Plugin Author codepeople

    (@codepeople)

    Hello @snice

    Yes, you simply should to use the PREC operation as the outermost operation in the equation, as follows:

    
PREC((POW(14.2/(1+7.3*POW(2,-1*fieldname1/96)),3)+POW(fieldname1/51, 2.91)-8)*0.993, 2)

    Best regards.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Formula Help’ is closed to new replies.