Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 3 columns
Subject Difficulty-level Score Weighted Score
Math 90 85 30.00
English 70 92 25.25
Physics 95 75 27.94
Total 255 83.20
What I am looking is for new Column called Weighted Score where the calculation is as below
Score * Difficulty-level / Total Difficulty-level
i.e.,
85 * 90 / 255 = 30.00
92 * 70 / 255 = 25.25
75 * 95 / 255 = 27.94
Total 83.20
I tried using a Qlik Sense formula as below, but did not work.
Score * Difficulty-level / sum(Difficulty-level)
But above did not work.
Help is appreciated. Thanks
@Rich5678 try below
Score * Difficulty-level / sum(total Difficulty-level)
Thanks very much, very helpful
@Rich5678 try below
Score * Difficulty-level / sum(total Difficulty-level)
Many thanks for quick reply,
but I copied your solution exactly, and unable to get it right
@Rich5678 could you post screenshot of what is wrong and what it should be?
Thanks very much, very helpful