Selecting multiple values in GetFieldSelection

[#1]

Hi All,

I am using the [Response ID] <> GetFieldSelection([Response ID)] to get the sum(score) for the value selected which are unselected in Response ID list box, however unable to achieve it.

Need assistance. I am using personal edition, hence cannot open others workbook.

[sunny_talwar]

May be this:

If(GetSelectedCount([Response ID]) = 0, Sum(score), Sum({<[Response ID] = e([Response ID])>} score))

[#3]

Hi Sunny,

The syntax did not work.

Let me explain the requirement

We have a field named Response ID.

For example we have 100 response Id. We need to show a Combo chart with Bar showing the score just one responded which is selected and a referene showing the avg score of other 99 respondent.

I hope this helps.

[sunny_talwar]

Did it give incorrect result? Did it give you any error? What exactly did not work?

[#5]

Hi Sunny,

Please find the attached workbokk for reference.

[sunny_talwar]

This?

Expression used for line

If(GetSelectedCount([Response ID]) = 0,

  Sum({<Category -= {'Option'}>}Weightage)/Count({<Category -= {'Option'}>}Question),

  Sum({<Category -= {'Option'}, [Response ID] = e([Response ID])>} Weightage)/Count({<Category -= {'Option'}, [Response ID] = e([Response ID])>}Question))

[#7]

Hi Sunny,

Under Capabilty Line Measure, we are expecting the avg score to be as 66.66 i.e. 400/6

[sunny_talwar · Accepted solution]

Try this:

Sum({<Category -= {'Option'}, [Response ID] = e([Response ID])>} Aggr(Sum({<Category -= {'Option'}, [Response ID] = e([Response ID])>} Weightage), [Response ID], Category))/

Sum({<Category -= {'Option'}, [Response ID] = e([Response ID])>} Aggr(Count({<Category -= {'Option'}, [Response ID] = e([Response ID])>}Question), [Response ID], Category))

[#9]

Roger Sir !!! Bulls Eye

Correct Syntax, got the desired O/P