#Error Report Builder SSRS

Question

I am working with a exp value and on the true statement I am getting an #Error

Can anyone help me out. What I am trying to do, in a drop down menu, when selected All, it is just blank, when they select a name it figures the calculation. I try to take the 0 out so it is blank but it still #Error

In the true part it #Error

=IIf(Parameters!Officer.Value="ALL", "0",Sum(Field!MyBalance.Value, "ABC")/Sum(Fields!FullBalance.Value, "TotalBalance"))

What am I doing wrong

Answer 1

IIF is sensitive to the data type of the expressions.
IIF(1=1, 5, 25) works, but IIF(1=1, "5", 25) would not work because "5" is a string, and 25 is an integer.

HTH,

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Bill Green ,
Is the scope of "ABC" and "TotalBalance" in the expression you use a data set or a group? If they are from different datasets, you may need to use functions such as lookup, LookupSet, etc.
If it is not in the above situation, could you share the test data to help you resolve the issue?
Best Reagrds,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.