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.
It's a case sensitive also...
check you have exact same name and spaces..
exp is ok
= Count(distinct [Invoice Nr.])
share sample app
Retrieving data ...