Ratio between two columns

[drallam]

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?

[drallam · Accepted solution]

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)