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