Counting average on specific sum

[#1]

Hi,

I have a formula problem with an average calculation I am trying to set up. I have an app where I show different sales in different categories for different people using the following formula:

Count({$<[Sales Category]={"Shoes and other"}>} [Sales Person])

This formula works fine for its calculation, however when I try an rewrite it to an average calculation i cant seem to get it to work. This is the formula I have tried:

Count({$<[Sales Category]={"Shoes and other"}>})/Count(Sales Person)

but I cannot seem to get it to work. Help plz.

Cheers,

[jonathandienst]

Hi

There are a two syntax problems in your expression. Try this:

Count({$<[Sales Category]={"Shoes and other"}>} [Sales Person])/Count([Sales Person])

HTH

Jonathan

[MK_QSL]

COUNT({<[Sales Category]={"Shoes and other"}>} [Sales Person])/COUNT([Sales Person])

[SunilChauhan]

Count({$<[Sales Category]={"Shoes and other"}>} [Sales Person])/Count(Total <[Sales Category]>[Sales Person])

Try this

hope this helps

[#5]

thansk for the replies, however (sorry for not being clear on this) i do not want the calculation to be on the individual sales person but rather on all total sales/sales category. if i could write it freely i would want it something like:

(all sales for this category A) / (total number of sales people) = average sales category A

[MK_QSL]

COUNT({<[Sales Category]={"Shoes and other"}>} [Sales Person])/COUNT(TOTAL [Sales Person])

[SunilChauhan]

Count(distinct [Sales Person])/Count(Total <[Sales Category]>[Sales Person])

try this

hope this helps

[sunilkumarqv]

HI Nils

Use Aggr Hope you can make work with this function

= Avg( Aggr( count({<Sales Category={"Shoes and other"}>}),Sales Person ))

[#9]

i feel that this is close, but it does not really do what i want it to do. i just want the total on category A divided by total number of sales people, something like this

[Count(Sales category = "Shoes and other")] / Count(Sales Person)

why doesnt this work?

[SunilChauhan]

Try below

COUNT(Total <Sales category> [Sales Person])/COUNT(TOTAL [Sales Person])

provide Sales category aS DIMENSION

hope this helps