topic Re: Calculation Problem in QlikView

Calculation Problem

roee1983 — Wed, 28 Aug 2013 10:30:18 GMT

Hi all,

i will be glad to get some help with the next issue:

i need to calculate for each PRODUCT (A B & C) the next calculation : =round(sum(orders/ sum(total(orders) * ACCURACY BY UNIT)))

for now i get total for 3 of them of 59% if i will divide it for each product i will get 59% for A 59% for B and 60% for C.

does somone have any idea?

attched an excel file with the data.

thanks

Roee

CELAMBARASAN — Wed, 28 Aug 2013 10:43:59 GMT

May be like this

=round(RangeSum(orders/ sum(Total orders * ACCURACY BY UNIT)))

roee1983 — Wed, 28 Aug 2013 10:58:25 GMT

Hi,

now i'm getting 0

roee

CELAMBARASAN — Wed, 28 Aug 2013 11:25:42 GMT

PFA

You getting value 0.03.... while round off its getting rounded to 0.

roee1983 — Wed, 28 Aug 2013 11:48:10 GMT

Hi,

i'm getting 0.00561 for 3 of them.

thank you

Roee

CELAMBARASAN — Wed, 28 Aug 2013 12:02:17 GMT

For this case how you need to rounded off?

May be try this Round(Expression, 0.001)