I've done a good bit of looking around but I find myself stumped. I have tried multiple ways but I cannot make my calculations come out correctly. I am attempting to duplicate an OSHA rate which is calculated as follows: (200000*(recordable Incidents))/manhours
I created the necessary groupings:
TRIR Recordables=all the recordable incidents
TRIR Calculation= (200000*TRIR Recordables)
TRIR=TRIR Calculation/Manhours
The answers i'm getting are over 200000 when they should be closer to 4-5 digits with a decimal.
I've attached a test version of my data, any help would be appreciated.
Wrap your TRIR calculation with a sum(). That will aggregate the data. You can right click on the calculation in the measures pane and change the number format in the default setting to reflect 2 decimals.
