Support » Plugin: Calculated Fields Form » Formula Help

• Resolved WebSam

(@snice)

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.

(@snice)

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

(@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.