Set Greater Than another set

[#1]

Hi,

I'm trying to build a set based on values that are greater than another set. I started with this

Count({$ <QuestionID = {'Q22'}, Q22Benefit2 = {">=55"}>} RespKey)

the value 55 is actually meant to be an average of all scorse across a set of all products. So, I built this into my load script using a field called TBIOverallAverage. the expression became:

Count($ <QuestionID = {'Q22'}, Q22Benefit2 = {">=TBIOverallAverage"}>} RespKey)

This doesn't work.

The actual formula I want to get to is something like:

Count({$ <QuestionID = {'Q22'}, Q22Benefit2 = {">=

          Avg({$ QuestionID = {'Q22'}"}>} TOTAL <Country, Wave, TargetGroupID> Q22Benefit2RespKey)"}>} RespKey)

This is supposed to represent the number of RespKey who have a value that is greater that the average of all the values.

Any help would be appreciated.

Regards,

Pete

[swuehl · Accepted solution]

Maybe like

Count({$ <QuestionID = {'Q22'},

Q22Benefit2 = {"=Q22Benefit2 >=

          Avg({$<QuestionID = {'Q22'}"}>} TOTAL <Country, Wave, TargetGroupID> Q22Benefit2RespKey)"}

>} RespKey)

or

Count({$ <QuestionID = {'Q22'},

Q22Benefit2 = {"=Q22Benefit2 >=

          $(=Avg({$<QuestionID = {'Q22'}"}>} TOTAL <Country, Wave, TargetGroupID> Q22Benefit2RespKey))"}

>} RespKey)

Regards,

Stefan

[lironbaram]

hei

attch is an example

may be you'll find it helpful