I have make no. of employees same in each company,then what % should I add to each company

[swarajjoshi]

Hello Everyone,

I have a dataset in which I have a question i.e., If we have to make number of employees same in each company, then what percentage of employees needs to be added in each company.

here's the snapshot of my dataset

COMPANY	NO. OF EMPLOYEES	TOTAL NO. OF EMPLOYEES
ABC	150	857
XYZ	70	857
PQR	415	857
LMN	222	857

NOTE:- The last column (i.e. "TOTAL NO. OF EMPLOYEES") is calculated column which I calculated using summarize tool, you can always ignore the last column if you want. 

Now my question is, if I want to make the values of 2nd column (i.e. " NO. OF EMPLOYEES") same, then what % should I add to each of them. I just want the % and not make them same

[AngelosPachis]

Hi @swarajjoshi ,

Assuming that the percentage that needs to be added to each company has to be calculated based on the current company workforce, then the formula that will give you that percentage is the following:

([TOTAL NO. OF EMPLOYEES] - [NO OF EMPLOYEES])/[NO OF EMPLOYEES]

OR

([TOTAL NO. OF EMPLOYEES] / [NO OF EMPLOYEES]) - 1 

So for company ABC the percentage that needs to be added is :

(857-150) / 150 = 707 / 150 = 4.713 or 471.3%

You can use a formula tool to create a new column called percentage added and then use the expression above if that gives you the numbers you anticipate