Why doesn't this work? :P
=IIF(Fields!OnHandQty.Value <> 0 ,IIF(Fields!FourWeekAvg.Value <> 0,Format(Fields!OnHandQty.Value/Fields!FourWeekAvg.Value, "0.00"), "N/A"),"N/A")
The first IIF seems to work... the second one is displaying #Error.
Thanks!
Printable View
Why doesn't this work? :P
=IIF(Fields!OnHandQty.Value <> 0 ,IIF(Fields!FourWeekAvg.Value <> 0,Format(Fields!OnHandQty.Value/Fields!FourWeekAvg.Value, "0.00"), "N/A"),"N/A")
The first IIF seems to work... the second one is displaying #Error.
Thanks!