Skip to Content
0
Oct 26, 2020 at 04:30 AM

I need to translate SAP P10 maintenance hours to a report with specific rules

80 Views

Hi, I need help in WEBI to create a statement with allot of rules. Can anyone help?

Current column data:

Work Hours, Date, Day of Week

The rules:

-any time worked on Sat is 1.5 time with a min of 8 hours regardless of time worked

-any time worked on Sun is 2.0 time with a min of 8 hours regardless of time worked

-any hours worked over 8 during the week is 1.5

-any hours worked on a holiday is 2.0 time with a min of 8 hours regardless of time worked

-Thanks!