Skip to Content
0
Former Member
Feb 20, 2009 at 11:32 AM

formula to work out % of days lost

30 Views

Hello,

I am working on an absence query, and I need to be able to work out the total % of days lost for a specific org unit.

Currently I have my query looking like thisu2026

.....................Actual time offu2026..% of days lost

Chief execu2026u2026u2026505u2026u2026u2026u2026.....(505/1946*100)

Env Servu2026u2026u2026..642u2026u2026u2026u2026......(642/1946*100)

Schoolsu2026u2026u2026u2026.799u2026u2026u2026u2026.....(799/1946*100)

Totalu2026u2026u2026u2026u2026.1946u2026u2026u2026..

Where the bracket is I want to be able to create a formula to work this out. Currently the total in the rows is a simple formula, but unfortunately I cant use this total in the formula Iu2019m trying to create in the columns.

Does anyone know how I can do this?

Thanks in advance

Forhad