Hey Survey123 community,
I think I have some pulldata functionality with some calculations defining a dams flow rate given a user-defined elevation and user-defined gate statuses; there are 3 gates (2-20' and 1-35'). Am having trouble making this 'simple.' I was currently thinking about pulling the Q total in based elevation and subtract values from how many 20' gates are closed and if the 35' gate is closed using another 'two' pull data rows. Any other ideas out there?