This content has been marked as final. Show 2 replies
this is a attendance dashboard that I am working on that show a summary of employee activity
But if we drill down to department that has no absent employees the dashboard will look like this
I know this is because there are no rows of employees record but I have searched the internet and tried isnull,ifnull,number of records = 0, isnull(number of records) just to put a '0 employees absent' on there to no avail.
I have attached a similar workbook with one tab that show the text since there is data, and other tabs of my attempt to get '0 absent' to show.
In the preview the is output (although is not what I want, but is better than blank), but it just won't show on the worksheet.
Thanks for the help in advance guys!
Leong Leng Hong