Forum Discussion
Calculated functions and context
Do you want to get this percent for mornings, and also for afternoons. Or do you want to combine the use for morning and afternoon as usage for the day ?
Hi Kentyler, i'll try to clarify. Morning and afternoon are separate timeframes. I have a dimtable with 10 timeframes ranging from monday morning to friday afternoon. See image in original post: I calculate occupation per room per timeframe (G =F/C). After that I mark all lines 1 that have an occupation over 60% in column H. This is the first easy set of steps.
Now the question I would like to answer is what is the percentage of all timeframes per floor that are marked with an occupation over 60%. example: floor 1 has 2 rooms x 10 timeframes = 20 lines of which 9 are marked as 1 in column H. That would be 45%. The same goes for floor 2: it has 1 room x 10 timeframes of which only 2 are marked as 1 in column H. That is 20%.
It's the context needed for making the calculation of column G that i'm losing when i try to aggregate to floor level that I need help with.