Forum Discussion
Solved
Help with Division
Hello, I want to create a column that shows Total Absence Days by month divided by Total Headcount by month. I have so far. Any help would be appreciated. Total Days Lost Per Person =...
in the first sum after the column name you close the function with ) ?
in the first sum after the column name you close the function with ) ?
Hi
I dont think that's what I am looking for I think it might be CountRows for the headcount piece?
divide(SUM('DB Absence'[Total absence days]),Countrows('DB Headcount'[ID]))
- use distinctcount