Fixing Count Distinct Collect Returning 1

rhenry11 · 12/19/23

I want to calculate the number of values in a column that are unique. However, I'm getting a return of 1 instead of a full count. How do I fix this?

Formula: =COUNT(DISTINCT(COLLECT([PRJ Number]:[PRJ Number], [PRJ Number]:[PRJ Number], ISNUMBER(@cell))))

SteyJ · 12/19/23

Try this:

=COUNT(DISTINCT([PRJ Number]:[PRJ Number]))

rhenry11 · 12/19/23

This still returns a "1".

Is it possible that it is returning that because I have a column formula on? Is it just reading the formula?

SteyJ · 12/19/23

Try converting the number in PRJ column to a value

=VALUE(PRJ Formula here)

Answers