if statement

suvechha_b — Fri, 20 Sep 2013 13:19:01 GMT

if(Breakdown='Adherence to plan(Factory)',sum(inbound_orders)/sum(purchase_receipts),

if(Breakdown='Adherence to Plan(MAPE3)',RangeMax(0,1-($(vMap))),

if(Breakdown='Adherence to Plan(ARITH1)',Sum({<[Accuracy] = {'ARITH - 1 month'}>}[Actual Units])/Sum({<[Accuracy] = {'ARITH - 1 month'}>}[Forecast Units]),

if(Breakdown='Model Stock Units',sum(model_stock_units),0))))

Unable to calculate :

Adherence to plan(Factory)

Adherence to Plan(MAPE3)

Adherence to Plan(ARITH1)

where there is no value I want place 0 at that place .

Can anybody help me .

Thanks in Advance.

topic if statement in QlikView

if statement