Survey123 Report and or statements

02-10-2022 01:29 PM
New Contributor

Hi all,

I'm wondering how to achieve a statement in my report so that if my survey meets the criteria then the table will show. If it does not meet the criteria then I would like the table to now show. This is the formula I am using in S123 Connect, but am slightly lost how to replicate this in S123 Reports as I'm finding its only following the first statement and ignoring the rest.

${estimated_average_no_consumers}="less_50" and ${estimated_peak_no_consumers}="50_to_500" or ${estimated_average_no_consumers}="50_to_500" or ${estimated_average_no_consumers}="less_50" and ${estimated_peak_no_consumers}="greater_500"


Any help would be greatly appreciated.





Tags (1)
0 Kudos
0 Replies