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!
|
Results 1 to 1 of 1
Thread: SSRS IIF question
|
Click Here to Expand Forum to Full Width |