Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you share the Sample data to debug the issue
If you're looking to count distinct values try:
COUNT(DISTINCT [Alpha ])
otherwise for all values
COUNT([Alpha ])