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.