Group Expression gives #Error 1

[clanm]

I have an expression such as:

=sum(
IIF( Fields!QuantityType.Value="LB", Fields!TotalQuantity.Value ,0)
,"Grp_Number"

)

....Grp_Number is the grouping where I'm trying to insert this summation / total.

Under Grp_Number, I have a 2nd grouping by QuantityType, where there's two possible values, LB or NLB. So, a Grp_Number could have possible 2nd groupings of:

1. only LB

2. only NLB

3. both

The only problem is when there's no LB, then the expression comes back as #Error.

Any suggestions are welcome!

Thanks!

 

[Catadmin]

Do a nested IIF and put in a ISNOTHING() function that will change the value of LB to zero - or whatever value you want it to have - if it comes back as NULL or Blank.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[clanm]

Thanks Catadmin!

I'll try that.

I ended up doing the report in CrystalXI, since it was a better UI for the time being.