Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))
May be this:
If(GetSelectedCount([Response ID]) = 0, Sum(score), Sum({<[Response ID] = e([Response ID])>} score))
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.
Did it give incorrect result? Did it give you any error? What exactly did not work?
Hi Sunny,
Please find the attached workbokk for reference.
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))
Hi Sunny,
Under Capabilty Line Measure, we are expecting the avg score to be as 66.66 i.e. 400/6
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))
Roger Sir !!! Bulls Eye
Correct Syntax, got the desired O/P