Days allocation with 2 dates

[#1]

Hi everyone, I need your help. I’m working on a development about absenteeism, and I stuck with the actual data that I have.

At this day, my data is like this :

id_abs	B_date_abs	T_date_abs
12354	01/01/2014	20/04/2014
1454	23/02/2014	25/03/2014
8454	30/03/2014	01/04/2014

The goal is to analyse the % of absenteeism regarding the month selected or the year. So, for the first line, we've got 31 days of absenteeism in January, and 20 in february. 

If I want to see the amount of days in february, it'll be 20 days (1st row) + 6 days (2nd row). What will be the best way to allocate those days for each months ?

Thanks a lot in advance.

[marinasbc]

Hi Manish,

This is really useful, thanks. Any chance you can shed some light on how to do this with hour detail?

I managed to work out the proportion in an expression but I can only use it when analysing by employee and month EmpHours_in_this_month = ( Total_EmpHours / Total_EmpDays) / EmpDays_in_this_month

I would like to do this on the script, can anyone help?

Thanks

Best Regards

Marina