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.
