Aggr function

[#1]

Hello everyone,

I have a problem when i'm using the aggr function.

I have the number of sales per store(DEALER_NAME):

i'm using the following expression : = count({1} SALES)

Each store has salesman and I'm trying to get the participation of each salesman in their stores.

I'm using : =count(SALES)/sum(Aggr(NODISTINCT count({1}>} SALES),DEALER_NAME)

but for the store 4, I get some weird results.

So I put the following expression in a text object :

=SUM(Aggr(NODISTINCT count({1< DEALER_NAME =  {'Store 4'}>} SALES),DEALER_NAME))

and it gives me 62469 as a result and I don't understand why.

Anyone has a clue ?

Thanks for your help

Sadjad

[jagan]

Hi,

Can you attach sample data and file, it helps in understanding easily.  I think count(SALES) is enough to get the number of Sales per Dealer since dealer is used as dimension.

Regards,

Jagan.

[#3]

Hi Sadjad,

Hope the below expression helps!

=count(SALES)/count({1} total SALES)

--

Vinoth

[#4]

try this

=count(SALES)/count(All  SALES)

or this one

=count(SALES)/sum({1} count(SALES))

[#5 · Accepted solution]

     Thanks guys but finally the problem was in the data.