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)
)
)
)
);
