I have a field on a Group Footer which is a Sum field based of an IIF statement.
Here it is.
=Sum(IIF(Fields!EXPR1.Value=2 and Fields!Type.Value=1,Fields!Quantity.Value,0))
If I do not use the AND, by by only checking on one field it works fine and it returns a result, however if I use the AND Operator I get the #Error when previewing the report.
Does anyone have any idea why this is happening. Any suggestion would help/
THanks
Can you try to get more information about the #Error? The output window should have something listed about your error.
Jarret
|||I figured this one out.
I used the cddl to convert the values to double values.
Thanks
No comments:
Post a Comment