Getting #Error when using SUM() RRS feed

  • Question

  • Hi there,

    I am getting an #Error shown in my report when I use the following code:

    =Sum(Fields!F0_YTD.Value - Fields!F0.Value + ((Fields!F0.Value/Parameters!WorkDaysThisMonth.Value)*Parameters!WorkDaysGoneThisMonth.Value)) 

    Only when the F0.Value=0. Why would this happen? It's mathematically sound.

    Any ideas? I don't get an error on the Detail row (without the SUM function)

    Sunday, February 15, 2009 11:03 PM


  • Nevermind, solved it myself. One of the fields was returning Empty not zero so wrapping each variable in a CDbl() fixed the problem.
    • Marked as answer by MWanstall Monday, February 16, 2009 1:20 AM
    Monday, February 16, 2009 1:20 AM