ncelis Member

Thank you @PoonamTrivedi !! I did not realize this was already a feature. I appreciate your help!

I was notified that voting was closed on this idea, but there's been no update on development. Is there a new ETA?

So I am closer to a solution using this Beast Mode: COUNT(DISTINCT CASE WHEN (Team Member Status = 'Active' OR Team Member Status = 'Unpaid Leave') THEN Team Member ID END) / COUNT(DISTINCT Date Scaffold) This "Average Headcount" now matches my "Active Headcount" totals on a daily basis which is great! (There are 2 lines…

Thanks @Jones01 but now I receive an error stating that one of the columns does not exist (event though all columns we're recognized in previous calc). I wish Domo error messages were more descriptive:

Thanks @MichelleH, but it looks like Domo is still throwing an error. Here is your calc with my specific field names, and the error message: