Id wise display the rolling sum

[Ramu_i]

Hi All,

Employee data is available,

Here Data is

R_EMP ID	R_Emp Name	R_Sal	Month	Year	Leaves	Joining Date
1	Ram	10000	Jan	2022	1	01-05-2022
2	Raj	20000	Jan	2022	0	02-05-2021
3	Soni	15000	Jan	2022	0	03-05-2020
1	Ram	10000	Feb	2022	0	01-05-2022
2	Raj	20000	Feb	2022	2	02-05-2021
3	Soni	15000	Feb	2022	3	03-05-2020
1	Ram	10000	Mar	2022	0	01-05-2022
2	Raj	20000	Mar	2022	0	02-05-2021
3	Soni	15000	Mar	2022	0	03-05-2020

O/P:

R_EMP ID	R_Emp Name	R_Sal	Leaves	Number of working Days
1	Ram	30000	1	2022-300 days,2021-315 days
2	Raj	60000	2
3	Soni	45000	3

Number of working days display the total number of working days in the particular year. Only working days(Mon-Fri).

Thank in advance.

Ram

[vikasmahajan · Accepted solution]

PFA attached QVF you can Network function