Avg Revenue Logic

[ajsjoshua]

Hi all,

I want to calculate the Doctor wise Avg Revenue

the avg revenue of these two doctor is 3,508 but i am not sure of the formula

what will be the logic behind this

4,242          DR. ABDUL GHANI

1,782           DR. SACHIN

3,508

Regards,

Joshua.

[tresB]

Have you tried avg() ?

[ajsjoshua]

Hi tresesco,

I am yet to try it in qlikview

I got stuck while analysing the excel data itself.

[marcus_sommer]

Maybe this is helpful: Average – Which average?

- Marcus

[tresB]

In excel there is AVERAGE()

[ajsjoshua]

Hi tresesco,

Average function gives me 3012

but user answer is 3,508

[ajsjoshua]

Hi Marcus,

Avg fuction gives 3012

but user answer is 3508.

[marcus_sommer]

Per pure maths is 3012 correct by only two records of 4242 and 1782. Therefore I assume that there more records are included or that there is some weighting. Please share more details to them.

- Marcus