Sum first x rows of data in report

  • [Figured it out, if anyone is interested]

    Something along the lines of:

    =SUM(Iif(Fields!A.Value=0,0,

    Fields!A.Value))

    /

    Iif(Fields!A.Value=0,1,

    SUM(Iif(Fields!A.Value=0,0,

    Fields!B.Value)))

    So this assumes (in my case) column A is the one that typically falls behind in updates. I gauge the presence of a number in that field for each row to calculate both numerator and denominator.

    Worked fine for me. Maybe it will help someone else...

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply