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))
Thanks in advance.
Survey123 SurveySurvey123 Geonet
Solved! Go to Solution.
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)
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)
Thanks for the help Doug that solved it.