Forum Discussion
drallam
Helper II
Helper IIRatio 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 types of employees are in the same table but in different rows. Please see picture below.
How do i apply ratio formula, and if so where?
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)
1 Reply
drallamFigured 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)