divide by expression

[#1]

Hello

I want to devide some values but i cant find the correct expression

i've a tabe witch som coloms with sum expressions and a total

sum (), sum () , sum () and sum ()+sum ()+sum()

now i want to make an other expression wich gives me the divide of , and

sum +sum +sum/3 does not give the correct answer ex a=5, b=4 and c=7 outcome shout be 16/3=5,3 but outco...

Avg (++) does not work either, outcome qlikview = 16

Avg (sum () + sum () + sum () gives error in expression

below a screenshot

help me

grtz Ed

[MayilVahanan · Accepted solution]

HI

(sum (a)+sum (b)+sum(c))/3

Hope it helps

[#3]

yeh thanx was correct,

grtz Ed