Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I sure it is trivial for an advanced user. However, I dont manage to use the count distinct formula correctly.
I type: Count(distinct[Invoice Nr.])
I only get "-" as an answer, although I have several hounderts of invoice numbers.
What am I doing wrong?
Thanks much in advance.
count( distinct [Invoice Nr.])
The space is important, though the reason for this I do not know.
Regards,
Michael
It's a case sensitive also...
check you have exact same name and spaces..
[Invoice Nr.]
exp is ok
= Count(distinct [Invoice Nr.])
share sample app