Post reply

Sum first x rows of data in report

  • June 23, 2008 at 12:01 pm

    #187401

    I have two columns that get updated behind the scenes, out of synch.

    How can I tell the footer to "take the sum of column A, divide that by sum of column B" but only up to the point where both columns have a value?

    (e.g. on a monthly report, values are in for both columns through April, so do sum(a)/sum(b) through April, ignore the fact there's a value in (b) for May since (a) isn't filled in yet)...?

    Thanks!!

  • June 23, 2008 at 1:04 pm

    #832987

    [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 2 posts - 1 through 1 (of 1 total)

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