Weighted performance

[alba_delvalle]

Hi,

I need help to perform a weighing in Qlik.

These are the data to use:

On this date, we have a line of work 'L103', two shifts 'A and B' and two products.

The shift A did two products '03742 and 03491' and the shift B did one product '03491'.

The table shows the units produced (Units), the time used (Time), the nominal objective for each product (Nominal) and the available time of the line (avaliable time).

The table shows a efficiency (efficiency=yield), result of a formula which I explain below:

(((sum(Units)/(sum(Time)))/(Nominal))*sum(avaliable time))/(sum(total avaliable time))

This individually gives correct, the problem comes when I want the performance per work shift or the global per line because I got zero.

What I need is to convert the following formula into qlik language.

(The numbers used are those of the table)