0 Replies Latest reply: Sep 26, 2016 6:52 AM by Diana Sarangaya RSS

    Calculating the average/value

    Diana Sarangaya
      LOCATIONFACILITYWAITING TIME
      LOCATION 1FACILITY 110 SECS
      LOCATION 1FACILITY 25 SECS
      LOCATION 1FACILITY 320 SECS
      LOCATION 2FACILITY 110 SECS
      LOCATION 2FACILITY 20 SEC
      LOCATION 2FACILITY 310 SECS

       

      I need to calculate the average waiting time and make it appear in a text box for both locations should be ( 9.2 SECS) average waiting time for location 1 should be (11.7 SECS) and location 2 should be (6.7 SECS) and also make the individual value appear as it gets filtered from the other tables.