+16Hi Experts,
I’m trying to do a overtime calculation using the calculation formula definition, I'm basically trying to fetch a wage code from time card results and multiply by 1.5 and display in another wage code,
the below is the setup,
I’m not getting the anticipated results, Could someone help me to understand what am i doing wrongly here.
Best Regards,
Best answer by Frank Weber
I try to recreate:
I create field for saving numbers and add number to field
Then I get the wage code I want to multiply the 1,5 with (I will Fetch Z001 which are the normal hours in this environment):
Then I make the multiplication:
Then I want to add the result og the multiplication to the results in the time card (I take wage code Z900):
I add the rule to the selection group (please be aware of the validity period!):
Then I register an intervall in the time card and get this result:
Remark: Z900 is already used in additional result calculation! So I get 8 hours from there. I expect additional 12 hours (8x1.5), so total of 20 hours:
Please keep in mind, that you will always need an intervall in the time card. This works as a trigger for the start of the calculation. This intervall can also have 0 hours (something like 14:00 to 14:00).
+16
Hi
I had somethin similar in the past. You should try the following.
First You need a field for saving numbers:
Then you add a fixed number (in your case 1.5 but in my screenshot it is 30) to the field:
Then (as you already do) you fetch the wage code you want to multiply and then you make the multiplication. So if you fetch your wage code in #30 for example your multiplication would be
So you would need 2 additional lines.
+16Hi
I made the changes you suggested and the formula looks like below,
Still I don't get the intended results, Also I assume these calculations are expected to work automatically if the conditions are met?
No. You have to connect the Calculation formula to a Selection Group:
And the selection Group is connected to an employee in the employee file
What are your conditions?
+16Hi
Itseems my setup is not correct to fetch the expected details,
I try to recreate:
I create field for saving numbers and add number to field
Then I get the wage code I want to multiply the 1,5 with (I will Fetch Z001 which are the normal hours in this environment):
Then I make the multiplication:
Then I want to add the result og the multiplication to the results in the time card (I take wage code Z900):
I add the rule to the selection group (please be aware of the validity period!):
Then I register an intervall in the time card and get this result:
Remark: Z900 is already used in additional result calculation! So I get 8 hours from there. I expect additional 12 hours (8x1.5), so total of 20 hours:
Please keep in mind, that you will always need an intervall in the time card. This works as a trigger for the start of the calculation. This intervall can also have 0 hours (something like 14:00 to 14:00).
+16Hi
Thank you so much for the detailed explanation and taking time to do this. Entering an interval made the calculation work earlier i was trying to register it a a result.
Thank you so much.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
