Unable to RANK from Lowest Amount When the Item Is Only One

jspascual

Hello, 

 

I hope you're all doing well.

 

I have this problem that's preventing me from proceeding on to the next steps. 

 

I'm trying to rank the basic salary from lowest to highest, by position. 

As we all know, even if employees have the same position, there are instances that they don't have the same salary.

The idea is, I need to get the lowest salary per position. 

The issue I'm encountering is that, if I do a rank formula, it does return the correct order when there are more than 1 employees. 

But if the position is assigned to only 1 employee, meaning only 1 employee has that position, it always returns 2. I need the value to be 1 since that will be my basis of getting the salary amount: IF Rank = 1 THEN Basic Salary ELSE 0. 

 

Thank you for all the inputs you may share.

 

Regards,

 

Jonathan

jspascual

Sending an update.

 

Thank you for your reply, @jasonblinn 

It gave way for me to think further. 

I think this has been addressed:

1. I created a step line item that would rank all of the employees' salary 

2. Then another line item that ranks the step 1 above by position title. 

I only needed the '1' lowest per position title and gave me that for both 1 employee or more than 1 employees assigned to a role. 

Thank you again!

 

Jonathan