Sum unique hrs in a Table

Question & Answer
, ,
1

My dataset has an Employee that has taken many trainings, but has also worked some {Hrs} on the same day. I want to get the sum of {hrs}, as a calculated field, that the employee has worked, where the training_complete field is equal to the hrs_end_date field.
Ideally, I should get 10.91 as my total hours.

{EMP ID}    {Training}     {Hrs}      {traning_complete}     {Hrs_end_date}
12345            001           10.03           April 2, 2025          April 2, 2025
12345            002           10.03          April 3, 2025          April 2, 2025
12345            003           10.03          April 3, 2025          April 2, 2025
12345            004           10.03          April 3, 2025          April 2, 2025
12345            005             0.88          April 3, 2025          April 3, 2025
12345            006             0.88         April 2, 2025          April 3, 2025
2

Hi @bunmis ,

You can use sumif to do the same calculation. It should look something similar to
sumIf( hrs, training_complete = hrs_end_date)

Thanks,
Prantika

3

Hi @bunmis,
It’s been awhile since we last heard from you on this thread, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

4

Hi @bunmis,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you!