Calculation Problem

[roee1983]

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]

May be like this

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

[roee1983]

Hi,

now i'm getting 0

roee

[CELAMBARASAN]

PFA

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

[roee1983]

Hi,

i'm getting 0.00561 for 3 of them.

thank you

Roee

[CELAMBARASAN]

For this case how you need to rounded off?

May be try this Round(Expression, 0.001)