How to find Avg and Total.

[#1]

Hi Folks,

I have student table, in this table have

hltno,sno, m1, m2, m3 fields

I need to find out avg and also total

Form back-end and front end of each student wise.

[avinashelite · Accepted solution]

In frontend ..

Add hltno,sno, m1, m2, m3 as dimension and in the expression

Total: sum(m1)+sum(m2)+sum(m3) --- this will give the total

Avg: AVG(m1+m2+m3) or (sum(m1)+sum(m2)+sum(m3))/3 ------ as you have 3 subjects

[amit_saini]

Hi,

u can use these settings while you have data in charts.

Thanks,

AS

[#4]

Total: sum(m1)+sum(m2)+sum(m3) --total

Avg: AVG(m1+m2+m3);