Support » Plugin: Calculated Fields Form » Formula Help

• 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)
• 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.

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

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

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.