R
Rambler_358
Guest
I'm running VS Pro 2017 with the latest update v15.9.13, and I'm getting a divide by zero error in an expression I have in a textbox, resulting in a "#Error" showing. The actual error is:
Severity Code Description Project File Line Suppression State
Warning [rsRuntimeErrorInExpression] The Value expression for the textrun ‘Accepted_HCCs.Paragraphs[0].TextRuns[0]’ contains an error: Attempted to divide by zero.
The actual expression I'm using is:
=IIf(Fields!Invoiced.Value = 0, 0, Avg(Fields!Accepted_HCCs.Value / Fields!Invoiced.Value))
The record that's causing the issue has both the Invoiced and Accepted_HCCs values as zero, but I'm using the IIf function to try and trap it, but it's not working. Any ideas why?
Rambler_358
Continue reading...
Severity Code Description Project File Line Suppression State
Warning [rsRuntimeErrorInExpression] The Value expression for the textrun ‘Accepted_HCCs.Paragraphs[0].TextRuns[0]’ contains an error: Attempted to divide by zero.
The actual expression I'm using is:
=IIf(Fields!Invoiced.Value = 0, 0, Avg(Fields!Accepted_HCCs.Value / Fields!Invoiced.Value))
The record that's causing the issue has both the Invoiced and Accepted_HCCs values as zero, but I'm using the IIf function to try and trap it, but it's not working. Any ideas why?
Rambler_358
Continue reading...