divide by expression

[#1]

Hi guys,

I want to divide som values but I cant find the correct expression .

I have a table witch some coloms

sum(a)

4471

sum(b)

5572

sum(c)

925

I want to make an expression

sum(a)/(sum(b)-sum(c))    

4471/(5572-925)  =0,926

but i Qlikview outcome 0,73

Thanks in advance

[dmohanty]

Hi,

Use this:

=Div (sum(a), (sum(b) - sum(c)))

[manideep78]

LET vDiff= Sum(b)-Sum(c);

then do this,

sum(a)/$(vDiff)

hope it helps

[#4]

Thank you!

[#5]

Thank you! It works

[er_mohit]

hi

your expression is absolutely write i don't know why it didn't give you correct answer..

sum(a)/(Sum(b)-Sum(c))

see the attached file