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,
Page 1 / 1
@Frank Weber - could you share any inputs on this
Hi @Dharshankumaar Mahendran
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.
Hi @Frank Weber - First of all thank you so much for the swift response. This functionality always seems to be useful but something which I'm trying to get my hands around it and having someone to respond to questions is really useful and thank you again for that.
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?
@Dharshankumaar Mahendran
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?
Hi @Frank Weber - I'm sorry I didn’t mention this I have already connected the employee to the selection group.
Itseems my setup is not correct to fetch the expected details,
Hi!
And you have an intervall registered in the time card?
I try to recreate:
I set up the formula header
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).
Hi @Frank Weber ,
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.