Forum Discussion

jamieham's avatar
jamieham
Helper II
4 years ago
Solved

Calculate Work : Rest Ratio %

Im trying to calculate the Work : Rest Ratio as a % for a game. I have the Total Match Duration which is displayed as 01:53:39 and the Ball In Play Time which is 00:37:42.

 

Any suggestions on how I can calculate this please?

Need Help

1 Reply

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    4 years ago

    jamieham 

    you can try 

    Column = ('Table'[total match]-'Table'[play time])/'Table'[total match]