I am trying to create a form to collect line-point intercept data within Survey 123. I have most of the meat done, I just need help with some calculations. I currently have the survey set up to collect multiple points of data with the begin repeat and end repeat functions. I need to be able to calculate PERCENT FOLIAR COVER by taking the total number of entries for my "TOP LAYER" field across the entire repeated survey then divide those over the total number of points sampled and multiply by 100 to get my average percent.
I need to do the same thing to determine PERCENT BARE GROUND, which is calculated by taking the total number of soil entries in the SOIL SURFACE question AND have no answers in the Top LAYER field, dividing the total number of points, and multiplying by 100. The same thing for PERCENT BASAL COVER, but it can include any entries with entries in the TOP LAYER or subsequent fields.
My XLSForm and an example of the data sheet I am trying to replicate are attached so you can see where I am at.
Thanks in advance for any help.