Forum Discussion
Solved
Ratio between two columns
Hi, I have a data set of two types of employees. These two types of employees are mixed together in various projects. How can i calculate ratio between these two employees per project. The two ty...
Figured it. Created two additonal columns and used if statements to create blank and filled cells.
Used Measure and used DIVIDE(COUNTBLANK(Column1),COUNTBLANK(Column2),0)
Figured it. Created two additonal columns and used if statements to create blank and filled cells.
Used Measure and used DIVIDE(COUNTBLANK(Column1),COUNTBLANK(Column2),0)