average calcualtion context

[former_member199945]

Hi ,

We are not getting average calculation correctly in below scenario can some one help .

Name Branch type   line number  measure1

ABC     123     O      1234             10

ABC     123     O       345               20

ABC

123

O        456              30

Def      456      P         567              40

Def    456        P         678               60

Def    456        P        679                 80

final o/p   :  name branch type average(Measure1)

                  ABC      123  O        20

                   Def         456  P       60

Average is showing wrong in webi

Thanks.

[Former Member]

What colums are in your final block?

How are you calculating average?

If you have Name, Branch and Type in your block, use:

=sum([Measure 1])/count([LineNumber])

Bear in mind that results may vary depending on the objects in your block.

[tanveer1]

what values are getting instead ?

You Could use the belwo formula instead of just avergae ([measure1])

=Average([Measure1] ForEach([Line number]))

Thanks,

Tanveer.

Message was edited by: Tanveer Ahmed Mohammed