Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a dataset with 6 dates where the dates are crosstabled. When I do a count on datefield, count(datefield), I get a count over 100. Is there any way to only get a count of 6, for 6 days?
Thanks.
Perhaps count(distinct datefield). If not you'll have to give more information about your dataset.
Hi,
Try to use DISTINCT in Count function.
=Count(DISTINCT DateFieldName)
Regards,
Jagan.