Skip to Content
0

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

Mar 02, 2017 at 07:50 AM

88

avatar image

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?

bobj-issue-1.jpg (132.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jyothirmayee A Mar 03, 2017 at 05:46 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded