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.
Cheers,
JaimeSmith2412