Calculation with SUM in RDLC file RRS feed

  • Question

  • I have a SUM function that doesn't work(the report stops with error : 'program cannot be loaded') and I don't know why :

    =SUM(Fields!FixedPriceUren.Value)/(Sum(Fields!AantalUur.Value) - Sum(Fields!NotPercUren.Value))


    they are all existing fields, I just want to exclude the NotPercUren in the calculation.

    could you please help me? thanks in advance!

    Tuesday, June 21, 2011 11:10 AM

All replies

  • I think it is a pity that nobody responds and helps me with this, I expected more of this forum. :-(


    Wednesday, June 22, 2011 9:19 AM
  • Write the expression Sum(Val(Fields!NotPercUren.Value))

    Val() will convert from string to number otherwise you get #Error

    • Proposed as answer by radumi Tuesday, September 20, 2011 3:11 AM
    Tuesday, September 20, 2011 3:11 AM