Collection Formula - Missing Counting Values

(0) Share

Report

Posted on by RH-25092337-0

Hi All - I am creating a collection and having an issue, whereas my code is adding the values up wrong.

In particular, I am building a collection of individuals by race. My collection accurately returns the following:

Alaska Native, Black, Caucasian, Hispanic, Native Hawaiian - all of which calculate correctly

However when calculating the "Asian" value with the "Caucasian" value. For whatever reason(s), it adds the "Caucasian" values correctly, but in the case of "Asians", it is adding the "Caucasian" value to it.

I can see where the string "asian" is true in both strings. Is there some function that would be more specific/deliberate in differentiating the two strings? Is there a function that I can add to my code to assist?

Thanks.

- - - SNIPET - - -

ClearCollect(

totAgentsByRaceCount,

AddColumns(

totalAgentsByRace,

AgentCount,

CountRows(

Filter(

'Agents',

totalAgentsByRace[@Race] in Text(Race)

)

);

Categories:

General Questions

All responses (2)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Re: Collection Formula - Missing Counting Values

HI @RichHarr,

Do you want to count Race column from totalAgentsByRace in Race column from 'Agents'?

If so, try to modify as below:

ClearCollect( totAgentsByRaceCount, AddColumns( totalAgentsByRace, AgentCount, CountRows( Filter( 'Agents', Text(Race) in totalAgentsByRace.Race ) ) ) );
Gochix 1,933 Super User 2025 Season 1 on at

Like (0)

Report
Re: Collection Formula - Missing Counting Values

@RichHarr ,

try using
totalAgentsByRace[@Race] = Text(Race)
rather than totalAgentsByRace[@Race] in Text(Race)

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!