Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
roee1983
Contributor III
Contributor III

Calculation Problem

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


5 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

May be like this

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

roee1983
Contributor III
Contributor III
Author

Hi,

now i'm getting 0

roee


CELAMBARASAN
Partner - Champion
Partner - Champion

PFA

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

roee1983
Contributor III
Contributor III
Author

Hi,

i'm getting 0.00561 for 3 of them.

thank you

Roee

CELAMBARASAN
Partner - Champion
Partner - Champion

For this case how you need to rounded off?

May be try this Round(Expression, 0.001)