Need help with where in expression and then avg number
Hi
I'm new to QV and i want to show the figure in a textbox and have the code in the expression if possible. Ward is a seperate column with column names and number of days is a column which displays figures. I want my text box to show, only add ward 1 and ward 2 and give me the average of the number of days.
=if(ward = 'ward1' and 'ward2)avg (Number of days)
