Calculating Average

[sudhir0538]

Hello Guys, I've 5 rating fields for every vendor transactions. I need to identify the average of these 5 fields against that vendor. How Can I achieve this through script?

Samples attached 

Column (G) is to achieve that is the average of Column (H,I,J,K,L). I've achieved this in chart by sum()/5. But how can i achieve this in script.

Thanks in advance.

[MayilVahanan · Accepted solution]

Hi @sudhir0538 

Hope all fields are coming from same table, in that case, you can do like below

RangeAvg(Field1,Field2,Field3,Field4,Field5) as FieldName

or

(Field1+Field2+Field3+Field4+Field5) / 5 as FieldName