Issue with If Condition in Master Measure ?

[zuberahmed]

Hi Folks , Greeting for the day , 

I am new to qlik trying to find Avg of Waiting Time Packaging for which logics goes as 

"Packaging Waiting Time – If coating is zero (Packaging start minus Compression end) OR (Packaging Start minus coating end)"

I am getting for two line items i.e. M & N block right however getting wrong for rest

This is what i am getting 

This is what expected 

My Formula for calculation Packaging Waiting Time is created in Master Measure

Please Suggest me how could i get to my desired result !!

I Have also attached Excel as base data for consideration

Thanks in Advance 

[martinpohl]

Hi,

i think you should calculate the value from your expression in your datas as a new field.

then you can exclude invalid combintions of filled fields also.

Regards