Distinct returns invalid value & Report issue I am trying to solve

BenRoller

I am attempting to do a unique on a date column and the column has blanks, is that the problem? Im trying to create a summary Grid to generate this report (probably not going to paste well

Genevieve P.

Hi @BenRoller

Can you post the formulas that you're using?

It sounds like a COUNT(DISTINCT(COLLECT would work for you, you would just need to make sure that the Date you're referencing in the formula is housed in a Date type of Column, so that when you reference it the formula can find the right value in the other "Planned Start" column.

Try something like this:

=COUNT(DISTINCT(COLLECT({Business Application Column}, {Planned Start Column}, Date@row)))

Let me know if this makes sense and works!

Cheers,

Genevieve