Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
hei
attch is an example
may be you'll find it helpful