Hi there, I'm extremely new to Qlik and am having problems replicating what is a very easy formula (SUMPRODUCT) in Excel in order to get the weighted average of some lines of data. Attached is the table I have created, in order to check the data is correct before I then create graphs. I have tried copying and pasting a few formula's such as AGGR, ONLY and set expression but I must be doing something wrong.
I need a weighted average of the ct_mic column, which should be the total sum of ct_mic*Net Kg divided by total sum of Net Kg.
I also need to know how to exclude the 0 values from this calculation so that the weighted average is correct?
Help!
