Skip to Content
author's profile photo
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Posted on Mar 03, 2017 at 05:46 PM


    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.







    Add comment
    10|10000 characters needed characters exceeded