Help Expression : calculate the number of people who work less than a year

[saadaouianouar]

Hello guys,

I would like to calculate the number of people who work less than a year.

in my data warehouse I do not have the variable which contains the deference between two dates: deference  date of entry date and date of exit 

(year([ExitD])-year([EntryD]))*12 +( num(month([ExitD]))-num(month([EntryD])))+1  it's working

now i want to calculate the number of employees who had work less than twelve months.

the SQL query which I want to create with 

select  count( id_trav)  FRom travail where Trunc(Months_Between(ExitD+1,EntryD))<12

[Gysbert_Wassenaar]

Perhaps something like this:
count({<EmployeeID={"=Age(ExitD,EntryD)=0"}>} distinct EmployeeID)

[saadaouianouar]

thank you but the solution that you proposed doesn't exactly work because there's an exception because there's one employee who has 12 months but it's counting him and is it possible to have indicator without the age function

Thank you for your time 🙂

[Gysbert_Wassenaar · Accepted solution]

That's probably because you're using a rather strange way to calculate the months.
For example, if ExitD is the 20180201 and the EntryID is 20170228 then you calculate the months as
(2018-2017)*12 + (2-2) + 1 = 13. And if you look at the dates then you can see that the person was really employed for less than a year. In fact closer to 11 months then 13 months.

If you don't want to use the Age function then plug in your expression instead.