AVG last 2 weeks IF current week is 0

Mon, 31 Jan 2011 18:33:47 GMT

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.

topic AVG last 2 weeks IF current week is 0 in QlikView