Hi, I am developing a dashboard that require total paid and unpaid FTE in a fiscal year or calendar year quarter. My dataset contains a row for each active employee in a month, meaning that an employee who is active in all three months of a quarter have three rows in the dataset. My calculation only need one active row in a quarter not three. Here's a sample dataset of three employees (A, B, C) each with FTE of 1 in the first quarter of 2021 Jan - A = 1, B = 1, C = 1 Feb - A = 1, B = 1, C = 1 Mar - B = 1, C = 1 Expected total paid FTE for the three employees in first quarter is 3 and not 8. If there's a document that will assist me on this, please direct me to it. Thank You!
... View more