Expression for greater than average of selected set

[#1]

Hi,

I'm trying to create an expression where the result is based on a scoring system and will return a '1' or '0' if the result is better than the average of the selected set (department/ region, etc)  I've tried all types of calculations, syntax but nothing works when I try to create the expression for the average of the entire selected set.  Could someone please point me in the right direction?

Thanks.

[Clever_Anjos]

Hard to find out without knowing more about your data.

I think something like this will count every item above the average of each item.

=sum(

  aggr(

  if(avg(value) >= avg(total value),1,0)

  ,item

  )

)

posting a qvw with your data, could help

[Nicole-Smith]

Maybe try putting the average calculation inside of dollar sign expansion so it isn't affected by other things on your chart:

if(Result>$(=avg(YourField)),1,0)

Or maybe you need total in the avg function:

if(Result>avg(total <DimensionsToInclude> YourField),1,0)

If you want further help, you may need to post a .qvw file: Preparing examples for Upload - Reduction and Data Scrambling