Set analysis in text object

[Anonymous]

Hi,

I would like to add Round_Type = {Qualifier}

To this text box expression:

=round(sum(Score)/Count(Round_Id))& ' Team Average Overall'

[Anonymous]

So, if Round_Type = 'Qualifier'

round(sum(Score)/Count(Round_Id

Essentially the average score when round is qualifier - in a text object.

[Qrishna]

=round(sum({$<Round_Type = {Qualifier}>}Score)/Count({$<Round_Type = {Qualifier}>}Round_Id)) & ' Team Average Overall'

[Anonymous]

No, the average is still overall, still the result of:

=round(sum(Score)/Count(Round_Id))

[shilpan]

=round(sum({$<Round_Type = {'Qualifier'}>}Score)/Count({$<Round_Type = {'Qualifier'}>}Round_Id)) & ' Team Average Overall'

[Anonymous]

I think that is exactly the same as Krishna's reply, and the output is the same as well - still the overall average without the Round_Type qualification of 'Qualifier'

[prma7799 · Accepted solution]

= Round(sum({$<Round_Type = {'Qualifier'}>}Score)

/

Count({$<Round_Type = {'Qualifier'}>}Round_Id))  & ' Team Average Overall'

[Anonymous]

Bingo!  Thank you very much.  Interesting I think I went down this road and got tripped up by the fact the syntax was not being highlighted correctly as the expression was being written.  I should have known to just keep plowing on - despite the fact QV does not always highlight as one might expect, it often winds up with "Expression OK" when finished...