This content has been marked as final. Show 3 replies
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
7 Bidadari 8.03
|3HOWW Hostel (Khao San)||8.2||8.0|
|7 Bidadari Seminyak||7.6||8.2||8.3|