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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Deepakkumar_A
Contributor
Contributor

Weighted Average Calculation

Can you assist how to get he D= Sum(B)/Sum(A) = 68.3% in the below table values ?

 

 

Month Category Actual Rate(A) Spent(B) Simple Avg(C) Weighted Avg(D)
January Hotel A  $                      1,241  $         654.46 52.7% 52.7%
January Hotel A  $                         712  $         425.74 59.8% 59.8%
January Hotel B  $                      2,139  $     1,853.93 86.7% 86.7%
January Hotel B  $                      2,139  $     1,829.25 85.5% 85.5%
Feburary Hotel A  $                      2,139  $         980.95 45.9% 45.9%
Feburary Hotel B  $                      2,139  $     1,767.56 82.6% 82.6%
Feburary Hotel A  $                      2,139  $         882.24 41.2% 41.2%
Feburary Hotel B  $                      2,139  $     1,067.32 49.9% 49.9%
March Hotel A  $                         748  $         542.32 72.5% 72.5%
March Hotel B  $                         748  $         636.42 85.1% 85.1%
March Hotel A  $                         748  $         542.32 72.5% 72.5%
March Hotel B  $                         748  $         579.39 77.5% 77.5%
March Hotel A  $                         748  $         688.86 92.1% 92.1%
March Hotel B  $                         748  $         720.07 96.3% 96.3%
     $                   19,274  $         13,171 Avg (C) 71.5% D= Sum(B)/Sum(A) = 68.3%
2 Replies
anat
Master
Master

if u r using qlikview can u try below options:

 

anat_0-1639683493963.png

 

Deepakkumar_A
Contributor
Contributor
Author

Hi can you please just in Qlik Sense. Also looking for solution as D= Sum(B)/Sum(A) = 68.3% in the below table values ?