teamwork123
asked on
SSRS 2005 Report error Division By Zero
Currently trying to compute percentage in BIDS SSRS 2005, on a footer group row from two text box's that sum up there column of values. Problem is when I run an IIF statement or a Switch statement i still receive the error. I have tried the following:
=Switch(ReportItems!textbo x22.Value = 0,0
,(ReportItems!textbox22.Va lue = 0 OR ReportItems!textbox13.Valu e = 0), 0
,ReportItems!textbox13.Val ue < 0, ReportItems!textbox22.Valu e / reportItems!textbox13.Valu e * 1
,ReportItems!textbox13.Val ue > 0, ReportItems!textbox22.Valu e / reportItems!textbox13.Valu e
)
=IIf(ReportItems!textbox22 .Value =0 OR ReportItems!textbox13.Valu e = 0, 0,
(IIf(ReportItems!textbox13 .Value < 0, ReportItems!textbox22.Valu e / reportItems!textbox13.Valu e * 1,
(IIf(ReportItems!textbox13 .Value > 0, ReportItems!textbox22.Valu e / reportItems!textbox13.Valu e, 0)))))
I have tried a few other combinations, but no good. How do I get past my error?
This statement below works as expected
=IIf(ReportItems!textbox22 .Value =0,0,(IIf(ReportItems!text box13.Valu e = 0, 0,1)))
Thanks
=Switch(ReportItems!textbo
,(ReportItems!textbox22.Va
,ReportItems!textbox13.Val
,ReportItems!textbox13.Val
)
=IIf(ReportItems!textbox22
(IIf(ReportItems!textbox13
(IIf(ReportItems!textbox13
I have tried a few other combinations, but no good. How do I get past my error?
This statement below works as expected
=IIf(ReportItems!textbox22
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.