Forum Discussion
Solved
Count and Group by - Urgent help
This is my data, I want to prepare a report to show the number of students accesses to the course. I have a day access a data field which I can use to count the number of days access to the course by...
kh0050 , usally when count, it should not count blank
count(Table[Day Access])
or can create like
calculate(count(Table[Day Access]), not(isblank(Table[Day Access])))
amitchandak
Super User
Super Userkh0050 , usally when count, it should not count blank
count(Table[Day Access])
or can create like
calculate(count(Table[Day Access]), not(isblank(Table[Day Access])))
Thank you. It is working perfectly. Is there a way blank or null can be replaced by 0 in my tables?
