Forum Discussion
Changing a calculated field based off date filter
Hello, I am working with employee data, more specifically, looking at Active vs. Terminated employees in a certain time period. Everything is dependent on the date filter. I have a hire date and ...
Thank you for providing these. I leveraged your formula. See below:
However, I am getting an error and I think it has something to do with the fact that I am doing an employee count and not summing an amount. I added a column, 'Employee Count' and gave it a value '1' and I thought then it would sum, but I keep receiving this error:
Greg_Deckler I was able to figure out the issue. There were blank dates in termination that caused it to error out. I was wondering if you have any idea why the status count total is saying 56 (bottom right table), instead of 11, which is what it is showing?