3 Replies Latest reply: Oct 23, 2015 2:00 AM by Gysbert Wassenaar RSS

    Urgent , average rating

    ben lim

      Hi all,

      I would like to create a new customized field call Average_Rating based on the information below.

      Example for 3D HomeStay, the avg rating should be sum of all three (7.5+.7.4.0) divide by 2 instead of 3 as I am treating 0 and null value  as insignificant as it will distort the value heavily. This applies to 3HOWW hotel too where the avg rating is 8.1

       

       

      Desired output for avg raating is

      3DHomestay 7.45

      3HOWW 8.1

      7 Bidadari 8.03

       

          

      NameRating_ARating_BRating_C
      3D Homestay7.57.40
      3HOWW Hostel (Khao San)8.28.0
      7 Bidadari Seminyak7.68.28.3