SAP BOBJ WebI: Average for last 3 months in a monthwise crosstab with data of all months

[Former Member]

Average function in WebI giving sum as the result when I try to include Where clause in it and filter to get the average for limited data(last 3 months) in a crosstab as shown in above image.

We tried all workarounds with ForEach, ForAll, In etc along with Where clause. But Nothing really worked. As we got the sum, for average we did like sum/count and that works fine. But the problem here is, we need to find out few other things like Standard deviation, etc for last 3 months which is difficult to achieve through the formulas. Can anyone help me on this?

[jyothirmayee_s]

Hi,

You are trying to do an Average on Avg which you already have and displaying in report.

Use the [Avg_Measure] where ( <Condition>)

Instead you can also dynamically create a formula to pull in last 3 months.

=RelativeDate(RelativeDate(

RelativeDate(CurrentDate();-DayNumberOfMonth(CurrentDate()));
-DayNumberOfMonth(RelativeDate(CurrentDate();-DayNumberOfMonth(CurrentDate()))));

RelativeDate(CurrentDate();-DayNumberOfMonth(CurrentDate()));
1-DayNumberOfMonth(RelativeDate(CurrentDate();-DayNumberOfMonth(CurrentDate()))));

2-DayNumberOfMonth(RelativeDate(RelativeDate(CurrentDate();-DayNumberOfMonth(CurrentDate()));
-DayNumberOfMonth(RelativeDate(CurrentDate();-DayNumberOfMonth(CurrentDate()))))))

Thanks,

Jothi