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