var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SSRS #Error
I have a problem in my SSRS Report where the #Error is being displayed
I have a matrix and in the textbox where the error is appearing I have a calculation: (A / B) * C
I have tried changing this to:
IIF(B = 0, 0, (A / B) * C)
That did not solve the problem
Then I tried:
IIF(ISNOTHING(B, 0, IIF(B = 0, 0, (A / B) * C))
And that to does not work
Can anyone help me with this please. I am pulling my hair out.
You look to have catered for the divide by zero error, but that's not the only one that might exist.
Are all your values actually numbers?
How are NULLs effecting your result?
I'd recommend outputting the actual values of A, B & C alongside the calculation to aide with debugging.
Not the best answer, sorry, but that's all I can give with the limited detail.