Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Can someone help me to get a set expression right.
I want to
Count({<Avgorsak ={9} >} Distinct PersonID) but only for those that dont have a HireDate that are larger than the EndDate
It´s a stright tabel that shows how many people that have ended ther hirings and don´t have come back later.
It´s the ones that have been rehired I want to remove.
Something like:
Count({<EndDate -= {'9999-12-31'}, Avgorsak ={9},PersonID={"=aggr(max(HireDate),PersonID)<=EndDate"} >} Distinct PersonID)
You may have to use the date# function to make a date of 9999-12-13. The expression editor doesn't understand -= but it's the correct syntax.
Perhaps like this:
Count({<Avgorsak ={9},PersonID={"=aggr(max(HireDate),PersonID)<=EndDate"} >} Distinct PersonID)
I think you are on the right way, but now I fund that people that are still hired are set to 9999-12-31 as enddate. In your above expression, how can I exclude that date?
Something like:
Count({<EndDate -= {'9999-12-31'}, Avgorsak ={9},PersonID={"=aggr(max(HireDate),PersonID)<=EndDate"} >} Distinct PersonID)
You may have to use the date# function to make a date of 9999-12-13. The expression editor doesn't understand -= but it's the correct syntax.