How to count fields in a column ?

[bouderbc]

Hi experts,

How to count fields in a column ?

i 'm using count ([Alpha ]) or text count ([Alpha ]) but the result is different from excel ?

Any solutions please ?

Regards

Ali

[krishnacbe]

Can you share the Sample data to debug the issue

[marcus_malinow]

If you're looking to count distinct values try:

COUNT(DISTINCT [Alpha ])

otherwise for all values

COUNT([Alpha ])