Skip to Content
0
Former Member
Oct 19, 2005 at 01:52 PM

HELP !!! average calculation

38 Views

Hi,

I want to calculate the average number of products sold by an agent. The formula is Avg = (nr. prod / nr. clients) where nr.prod is the number of unique products sold to a customer and nr. clients is the number of customers.

It works just fine when the customer is drilled down. In this case nr.prod is calculated fine, nr.client = 1 and the subtotal is calculated as average - that's what i want.

The problem occurs when I remove the customer drilldown - in this case the nr.prod is no more calculated as a sum of products for all the agent's customers but as the number of products for this agent.

The nr.prod and nr.client are calculated key figures as count all values for reference characteristic customer/material (in the aggregation exception).

thanx

daniel