Skip to Content
0
Former Member
Sep 15, 2005 at 03:54 PM

Average Balance

47 Views

I am trying to convert Report Writer reports to BW. On the one of the Sections in the report in report writer the colum has Average Balance as the Basic Key figure. I would Like to know how to achive the same in BEx.

The Report Painter uses this formula to calculate the Average balance (correct me if I am wrong).

Consider Amounts as 100, 200 & 300 in Jan, Feb & Mar Jan 100

Feb (10031)/(3128)(20028/(31+28))

Mar (10031)/(312831))+ ((20028)/(312831))(300*31)/(3128+31))

and so on.