Error with an expression in the footer of group RRS feed

  • Question

  • =iif(sum(Fields!QTY.Value) <>0.00, sum(Fields!QTY.Value)/sum(Fields!PR.Value),0.00)

    I have the above expression that says if the sum of one value is greater than 0.00, then do blah blah and else return a 0.00.  However, this expression works for some groups, but on others I get an error that looks like "#error".  The report in BI studio says it is trying to divide by a 0.00 which gives that error.  In my expression, it should never divide by a zero.  Any thoughts on what is wrong with my expression?

    Ryan Mcbee
    Monday, January 5, 2009 12:31 AM


All replies