Rewards & Recognition: Guidelines formula

[analousada]

Hi,

I need a formula way to have guidelines on Spot Award program. These guidelines should consider the 2%-10% of the Annual Base Salary per employee.

Do you have any idea how can I achieve this?

Many thanks!

Ana Lousada

[AndresCarter]

Hi Ana,
You could create a business rule to get the guideline value as a percent of the salary which the updates the award amount.

With the percentages you mention, how are you wanting to define these? based in the categories/levels only of other factors from EC, etc?

Thanks,

Andres

[analousada]

Hello @AndresCarter 

The idea is when the manager give the award, he will be able to see the defined guidelines 2%-10% of the Annual Base Salary per employee. The guideline will not have more criteria since will be configured per each program.

Many thanks!

Ana Lousada

[AndresCarter]

Hi Ana,

Apologies for the two comments, my keyboard was acting up 🙂
So, you could have the guidelines set with a value which you want to be a percentage. 
For example, below i have 2 for Mentoring and Team Player.

Within the business rules on the spotAward object we create the following.

We create a variable to get the salary of the employee, have the rule set to always true or for a selected program only, and use the Then to set the award amount to be salary*guideline.
When I tested this on an employee who's salary is 413,000.000 I got 2% correctly.

Hope this helps,
Andres

[AndresCarter]

Hi Anna,

[analousada]

Hello @AndresCarter!

Many thanks for your help. In fact, I had the challenge to find the correct scenario, since the Basis currently is not available. In the end my rule is with the following setup:

However, I am currently struggling to hide the currency (when the guideline is chosen), as it now refers to a percentage rather than a monetary value.

Do you have any idea?

Many thanks!

[AndresCarter]

Hi Anna - I think the best option there would be to create a pay component labelled percent/percentage and link this to the program. Then within the rule, set the award currency code to equal the currency code which is within compInformation. Something like this

Thanks,

Andres

[MeghaSadhotra]

@AndresCarterHi! I have a similar requirement. Would you please elaborate as to where should this rule be assigned to the spotaward? Thank you.

[AndresCarter]

Hi @MeghaSadhotra , The rule we want to have added to the spotAward object through Object Definitions.

I hope this helps 🙂

Thanks, Andres

[analousada]

Hello @AndresCarter,

I feel that the only difficult here is when we fill in the GUIDELINE_AMOUNT we are referring to the default amount and not the choice of the nominator. Do you have any idea how can we pick the value chosen? This way we will grant the possibility to the nominator to choose a value between 2%-10%. Many thanks!

[AndresCarter]

Hi @analousada - So the guidelines provide the various amounts based on the selected categories/levels. If we wanted to have this guideline amount or any manually entered amount by the nominator to be a % of salary, then this will also work.

In the end, the initial nominated award amount is 2 but we are changing this amount to be current salary multiplied by 2. We can adjust the rule to be from the amount amount rather than guideline.

Thanks!

[analousada]

Hello @AndresCarter

I am returning to this topic. I checked the screenshot that you provide and I saw that you select as validate rule on the object definition. However I am not able to use the "set" option and only the "execute" to create a validate business rule. Do you have any workaround? 

Many thanks!

Ana Lousada

[analousada]

Hello @AndresCarter,

Thank you so much for your help. I'm gonna to share all the steps that I perform in order to achieve the request:

1. Make sure that the advanced setting "Can nominators override the recommended award amount?" on Spot Award Program is enable. 

2. Create a rule to make the calculations and link with the MDF Spot Award Object.

NOTE: this rule is linked in Save Rule, but it was calculated 2 times. For that reason, I have added a condition to block the 2nd multiplication.

3. The last step, was to create a new Business Rule to make an interval between 2%-10%.

I hope that this helps you too @MeghaSadhotra. 🙂

Ana Lousada

[pal21]

Hi @ analousada , I have same requirement where i want nominator to give a number(between 1-10) which works as percentage rather than a flat amount in the field "Award Amount" on nominating screen. But even trying the above screenshots  i am unable to do so. also, i dont have any budget for this award. Please can you guide me with more screenshots.

[pal21]

Hi Ana Lousada, where have you added the last rule i.e rule number 3

[MeghaSadhotra]

@analousadaThank you. Just one query, where you able to solve for that USD showing next to 10% when Award Amount was selected?

[AndresCarter]

So, you could have the guidelines set with a value which you want to be a percentage. 
For example, below i have 2 for Mentoring and Team Player.

Within the business rules on the spotAward object we create the following.

We create a variable to get the salary of the employee, have the rule set to always true or for a selected program only, and use the Then to set the award amount to be salary*guideline.
When I tested this on an employee who's salary is 413,000.000 I got 2% correctly.

Hope this helps,
Andres