This discussion is archived
1 Reply Latest reply: Nov 9, 2012 6:29 AM by Frank Kulash RSS

Ratio calculation

948191 Newbie
Currently Being Moderated
Hi i need to calculate ratio of each manager with total number of employees vs total number of devices.
e.g total number of employees per manager 179 and devices 579
employees 38 devices 54
i want to display ratio in my report on Ratio column as manager1 1:2,manager2 1: 1 how can i do that, itried to divide the total number of employees over devices and gives .2233 and i cant get my mind into dispalying it as 1:2 or 1:1 please assist

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points