AVG last 2 weeks IF current week is 0

[#1]

Hi All,

I am trying to get the average of last 2 WW if the current WW is empty.

My code currently only return the current WW if have value

If(sum({$<[Oper Code]={'800.20'}>}[Qty Out])>0, sum({$<[Oper Code]={'800.20'}>}[Qty Out]) / sum({$<[Oper Code]={'800.20'}>}[Qty In]))

Please help.

Thanks in advance.