Calculating Average

sudhir0538 — Thu, 05 Nov 2020 05:34:12 GMT

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.

Re: Calculating Average

MayilVahanan — Thu, 05 Nov 2020 04:48:39 GMT

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

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

topic Re: Calculating Average in App Development

Calculating Average

Re: Calculating Average