Compare Text in a Count Expression

[yastaaa]

Hi,

I am doing this count:

COUNT(SELECT(Races[Sel_1],[Sel_1]=[win])) this give one result

If i do: COUNT(SELECT(Races[Sel_1],[win]=[Sel_1])) and this gives another result

None of the results are correct.

[win] and [Sel_1] are text columns that are referenced to another a table. The text colum is 2 character only for Horse Number. ie: 1,1A, 2,3,4 etc.

I dont know what is happening because in Google Sheets the same comparison is working.

---

COUNT(
…The list of values of column ‘Sel_1’
…from rows of table ‘Races’
…where this condition is true: ((The value of column ‘Sel_1’) is equal to (The value of column ‘win’)))

[Suvrutt_Gurjar]

Please try once with the following expression

COUNT(SELECT(Races[Sel_1],RIGHT(“0”&[Sel_1],2)=RIGHT(“0”&[Win],2)))

[yastaaa]

The problem seems to be when [win] is empty or blank. Seems that comparisons are count as equals even if they are not.

COUNT(SELECT(Races[Sel_1],AND(ISNOTBLANK([Win]),[Sel_1]=[win]))) This gives the correct result.

[Suvrutt_Gurjar]

Great. And yes, @Steve has guided nicely on this topic

https://community.appsheet.com/search?expanded=true&q=quirk%20%23ask

[yastaaa]

I have also problem with the division of the two counts gives 0 no the deimal or percentage.

Thanks.

[Suvrutt_Gurjar]

Please try

[Top Pick Winners]/([Top Races]*1.00)

[yastaaa]

Suvrutt_Gurjar:

[Top Pick Winners]/([Top Races]*1.00)

Thanks a lot. Worked.