For a sample project that I'm working on, I am trying to calculate the % of people coming into a building at least 3x or more a week. Each leader has a number of direct reports, and I was able create a calculated field that does the correct calculation if a specific leader is selected in the dropdown. This is the calculated field:
Officer % = {Fixed Week([Date]), [Manager]:[Entry Count]/MIN([Direct Reports])}
However, when "All" is selected, the entry count is correct but I am not sure how to get the sum of the direct reports which is 60. I tried to do SUM(Direct Reports) in the calculation above, but it is not correct.
I have attached the workbook here. Appreciate any help. Thank you!
hi @Richard S.
Change the calculation officer % to sum({Fixed Week([Date]), [Manager]:[Entry Count]})/
sum({ FIXED Week([Date]), [Manager]:MIN([Direct Reports])})
This will work, because if you are using the above mentioned formula by you, its taking min of whole data, this changed calculation will sum the min values and you will get 60.
Attaching the workbook for your reference
