Forum Discussion

drallam's avatar
drallam
Icon for Helper II rankHelper II
9 years ago
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...
Tips and Tricks
  • drallam's avatar
    drallam
    9 years ago

    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)

drallam's avatar
drallam
Icon for Helper II rankHelper II
9 years ago

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)