Hi,
I am using a beast mode calculation that results in a ratio for forward to manager : hire
CONCAT(Sum(CASE WHEN To Step
= 'Forward to HM'THEN 1 ELSE 0 END)/(COUNT(DISTINCT Requisition Number
)) , ':', Sum(CASE WHEN To Step
= 'Hire'THEN 1 ELSE 0 END)/(COUNT(DISTINCT Requisition Number
)) )
The result is this:
How do I get it to say 4.89 : 1.43 I've tried a bunch of things, but I can't get rid of the extra decimal numbers. Any help is much appreciated.
Thanks,
Gunjan