Average of Positive and Negative Number in Webi 4.0

[Former Member]

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

[LepreuxLoic]

Hi,

I would say you have identical rows which have been aggregated, or else your formula is based on another object.

Could you export data to csv to check exact content of your data provider ?

Regards,

Loic

[Former Member]

so basically , the count is the days between two dates , when i include the date in the block then the Avg comes fine , but when i remove the two dates from the block , then the avg is wrong . Following are the screen shot

Display Unit Number	Metrics R4	Qualification Visit Call Ac	Site Selected Ac
1	22	7/5/11	7/27/11
2	16	7/11/11	7/27/11
3	15	7/12/11	7/27/11
4	29	6/28/11	7/27/11
5	30	6/27/11	7/27/11
6	6	7/13/11	7/19/11
7	0	8/10/11	8/10/11
8	2	8/17/11	8/19/11
9	6	8/31/11	9/6/11
10	-27	9/21/11	8/25/11
Average:	9.9

but when  i remove it , it comes wrong

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.29

Question 1: why this is happening ?

Questions 2: How can i get the avg right , but i dont want to show the dates in the block , i know there is an Hide Option , but is there any other way. For Each and In is not working

[Former Member]

ok its working fine when i use IN function

=Average([Metrics R4]In([Site Selected Ac];[Qualification Visit Call Ac]))

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:	9.9

[former_member203850]

Hi Usman ,

Its working as per designed. Please see attached snapshot for the same.

Kindly verify the formulae.

Regards,

Pranay

[former_member203850]

Please provide the snapshot for average calculation.

Regards,

Pranay

[Former Member]

i placed the screen shot in the message itself and also attached as pic