Active Employees & Retention Rate

Hi,

I have checked and the number of brackets seems to be correct. I am not sure why it is not working.

This is what I am getting.

Yeah I see. It is related to your brackets after all you're doing this:

ISBLANK(DATE = true)

it should be:

ISBLANK(DATE) = true

What you are initially saying is:

Is date = true?

What you should be doing is:

Is a row of the column date blank

Thanks so much for double checking this for me .

All working fine.

I will look into the retention rate and get back to you.

Hi,

I have looked into the different options and as you advised, I believe a calculated column is better.

However, they are few things I need to take into consideration. My calculated column should not include any results where the finish date is in the past. I also have finish dates set up in the future and I would like to have the retention rate calculated as current not based on the future date. Lastly, some employees have been working for us in a matter of months and I would like it to be simply displayed as months without details but have it definite for years.

Would you be able to guide me ?

thanks

I've got a busy day today sadly but I can walk you through the concepts:

Concatenatex is your friend here, you can use that to filter a table to your liking and ONLY concatenate those. Try and alter the calculated column to return something of that format.