Forum Discussion

kneri3's avatar
kneri3
Frequent Visitor
3 years ago

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 ...
Need Help
  • kneri3's avatar
    kneri3
    Frequent Visitor
    3 years ago

    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: 

     

    • kneri3's avatar
      kneri3
      Frequent Visitor
      3 years ago

      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?