Total and Averages in a table

[MikeJones]

Hi, the first four columns of the table below shows my output from a table.  Total installs at 760 is the sum the of week's installs, whilst 8 shows the average number of employees working for the whole week. 

New No of Employees is the column I wish to generate.  Instead of showing 8 as the average, I wish to show the average only for Monday to Friday at 10.  I need to show the number working on Saturday & Sunday and installs for the whole week.  Any ideas as to how I could do this?

		Total	No	New No
		Installs	Employees	Employees
		760	8	10
2023-01-09	Mon	100	10	10
2023-01-10	Tue	120	10	10
2023-01-11	Wed	140	10	10
2023-01-12	Thu	160	10	10
2023-01-13	Fri	180	10	10
2023-01-14	Sat	50	4	4
2023-01-15	Sun	10	2	2

[MayilVahanan]

Hi

Try like 
If(Rowno() = 0, Avg({<Weekday-={'Sat', 'Sun'}>}ur_employee_field), ur_original_exp)