Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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% |
if u r using qlikview can u try below options:
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 ?