# Intermediate Algebra calculation in Survey123

138
2
08-21-2019 02:03 PM
Highlighted
New Contributor

Hi,

This is my first attempt at more complicated Survey123 calculations. The purpose is to automatically calculate timber volumes based on a few user entered values. The formula is simple, but there is a mistake somewhere in my syntax and I am missing where it is. My formula is as follows:

Gross Volume =

\${log1_length_gross}*((pow((\${log1_butt_diameter} div 100) div 2), 2)*pi())div 2) + ((pow((\${log1_top_diameter_gross} div 100) div 2), 2)*pi())div 2))

In excel I normally express the formula as follows:

= \${log1_length_gross}*(((((\${log1_butt_diameter}/100)/2)^2)*PI())/2)+(((((\${log1_top_diameter_gross}/100)/2)^2)*PI())/2))

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Frequent Contributor II

I think it is your pow().  You are ending the pow() before the ,2 part.

pow((\${log1_butt_diameter} div 100) div 2), 2)

should be

pow((\${log1_butt_diameter} div 100) div 2, 2)

2 Replies
Highlighted
Frequent Contributor II

I think it is your pow().  You are ending the pow() before the ,2 part.

pow((\${log1_butt_diameter} div 100) div 2), 2)

should be

pow((\${log1_butt_diameter} div 100) div 2, 2)

Highlighted
New Contributor

Thanks for the help Doug that solved it.