Skip to main content

For example, in the attached workbook, I am looking to count how many people that badged in at least once during that particular week. When they did not badge in at all during that week, it is blank. I want it to show a zero. I tried using this formula:

 

{ FIXED DATETRUNC('day', [Date]),[McID:]: IFNULL(CountD([McIDandPersonnelType]),0)}

 

However, it didn't work. I then would like to take the column grand total for each week. If someone can please assist, I would be most appreciative. Thank you!

3 respostas