Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Average of Positive and Negative Number in Webi 4.0

Hi Guys ,

I am trying to do an average for a list of number that also have Negative number in it , for some reason the Average is coming not as i do regular calculation .

Following is the calculation what Webi is doing :

As Average :13

Display Unit Number

Metrics R4

1

22

2

16

3

15

4

29

5

30

6

6

7

0

8

2

9

6

10

-27

Average:

13

But actually it should bring like 9.9 or as we rounding off in webi , so it should come as 10 .

22+16+15+29+30+6+0+2+6+(-27) /10 = 9.9

but in Webi its showing 13 in Webi
Average.PNG (8482 B)
Former Member
Not what you were looking for? View more on this topic or Ask a question