Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to add Round_Type = {Qualifier}
To this text box expression:
=round(sum(Score)/Count(Round_Id))& ' Team Average Overall'
= Round(sum({$<Round_Type = {'Qualifier'}>}Score)
/
Count({$<Round_Type = {'Qualifier'}>}Round_Id)) & ' Team Average Overall'
So, if Round_Type = 'Qualifier'
round(sum(Score)/Count(Round_Id
Essentially the average score when round is qualifier - in a text object.
=round(sum({$<Round_Type = {Qualifier}>}Score)/Count({$<Round_Type = {Qualifier}>}Round_Id)) & ' Team Average Overall'
No, the average is still overall, still the result of:
=round(sum(Score)/Count(Round_Id))
=round(sum({$<Round_Type = {'Qualifier'}>}Score)/Count({$<Round_Type = {'Qualifier'}>}Round_Id)) & ' Team Average Overall'
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'
= Round(sum({$<Round_Type = {'Qualifier'}>}Score)
/
Count({$<Round_Type = {'Qualifier'}>}Round_Id)) & ' Team Average Overall'
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...