Bex Get Total and Average of payment amounts

[Former Member]

Hello,

I have a requirement where I need to get Total amount as well as Average Amount for a given characteristic and Time period: Calmonth/Year 01/2002 - 12/2002. I just need one line/row report with 2 columns one for Total and another one for Average. I do not need to display a row for each month in the excel.

I can easily get the Total Amount but getting Average Amount is difficult as I am not displaying individul rows for each month. I also do not want to display over all results. Some months may or may not have amounts, so I need to average amounts based on number of non-zero amounts. I tried using "calculate result as average" of amount keyfigure property but it doesn't work.

Any help would be appreciated.

selva

[former_member184494]

Here you can calculate result as average but what it does is to calculate the result row as average of all results . If you want average , you could try using cell reference since you have mentioned that calculate result as average does not work and does your time period also vary / or is it a selection , if it is , then you can use cell reference or you can directly divide by 12 to get average ...

Arun

[Ashwin]

Hello suresh!

is this problem solved.... i mean i saw something simmilar to this quetion in other forum and it was solved.... Actually calculate result as average must work .

can you explain me whats happening if you select calculate result as average.

with regards

ashwin