0 Replies Latest reply: Dec 24, 2012 7:57 AM by lakwinder singh RSS

    Need help with where in expression and then avg number

    lakwinder singh

      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)

       

      Many thanks in advance.