Multiplication in Qlik Sense

[valnod_90]

Hi guys, I need your help.

In my company each order is made up of 11 or 10 production steps that vary depending on whether the bin is present or not.

The presence of the bin is evaluated in the "F_Cassa" field which has the value "1" if the bin is present, or "0" if it is not.

I need Qlik to multiply the number of phases per order and the number of job orders selected considering the value of the "F_Cassa" field.

For example, if I select an order with the bin and one without it Qlik will have to do this operation: 11 x 1 + 10 x 1 and obtain 21 as result.

I tried with an if statement but it doesn't work beacause, for example, in the case above i obtain 20 as result and not 21.

Is there a way to do this?

Thank you

[undergrinder]

Hi Valentina,

could you provide us some example data?

G.

[valnod_90]

Hi Gabor,

sure!

Look at the XLS file attached above.

I hope is enough.

Tnx