Absenteeism rate

jimmy1550 

This is a 365 solution:

=LET(
    multiplier, SEQUENCE(7, , 1, 0),
    out, MMULT(N(Attendance = "Absent"), multiplier),
    scheduled, MMULT((Attendance <> "OFF") * (Attendance <> "PTO"), multiplier),
    Analyze, LAMBDA(row,
        LET(
            absent, SUM(FILTER(out, LOB = row, 0)),
            total, SUM(FILTER(scheduled, LOB = row, 0)),
            absent / total
        )
    ),
    BYROW(UniqueLOB, Analyze)
)