count (total distinct)

[TomBond77]

Hi experts

Need to calculate with a reference to distinct values: This division is not working, the problem is located with the distinct id. How do I set it correct?

=[Working Days]

/

count(total [Date] (distinct id))

[udit_k · Accepted solution]

=sum([Working Days])

/

count(total <Date> distinct ID)