Problem subtotal Matrix RRS feed

  • Question

  • Hi everyone, I have a matrix and I need to add the money earned this year and past years. However, I must remove the money spent in past years. I must have the separate amount per year and the total of these amounts. This is what gives my matrix:
    = Fields!Year.value           =formatnumber((sum (Fields!Results.Value)) - (sum (iif (Fields!Year.value <Parameters!ChoosedYear.Value, fields!Moneyspent.value, 0))), 2) & "$"

    However, the subtotal gives me an error. What should I do?

    • Edited by rhap Monday, March 22, 2010 5:14 PM
    Friday, March 19, 2010 8:13 PM

All replies

  • I already found that the subtotal gives me an error because it's not in the scope of the rowgroup1, but is there a way to get the scope in the subtotal? or can anybody find another way to do it?

    Monday, March 22, 2010 2:20 PM