Divide by 0 issue in rdlc report RRS feed

  • Question

  • Hi there

    I have the following expression in an rdlc report. The results in this field is alwasy #Error, no matter how I change the 0 values. I have tried 0.00, I have even tried strings "0.00".

    =IIf(SUM(Fields!Bought.Value - Fields!Sold.Value) = 0,  
     SUM(Fields!SpotRate.Value *   
     (Fields!Bought.Value - Fields!Sold.Value)) /   
     SUM(Fields!Bought.Value - Fields!Sold.Value)) 

    This should have a smiple solution, but I cannot see it.

    Any help and suggestions are welcome.

    It's not the blowing of the wind that determines your destination, it's the set of the sail. J Rohn
    Tuesday, November 11, 2008 6:37 AM


All replies