How to count consecutive 7 days (it can be cross-week as well) in SuccessFactors Timesheet?

[former_member27647]

The 7th consecutive day worked by an employee is evaluated different from rest of the days. The 7th day can be out of the work week as well. For example, if a week is defined as Sun-Sat and an employee worked Tues, Wed, Thur, Fri, Sat, Sun, Mon continuously then Mon will be considered as 7th consecutive day.

Pls note : this query is regarding SAP SuccessFactors Timesheet

Pls do help me with your suggestions. Your help is highly appreciated.

Thanks,

[sanjaykwadhwani]

Hi Sushmit,

Interesting scenario. To count the days you can use counted events within time type group. Each day worked; you can add 1 to the counter. If the current days hours are zero then zero the counter; just an idea

EC Timesheet valuation rules are like ladder. If you are able to generate the value step by step and query the output for next processing it may work.

There are few blogs on counted events. It may provide some references.

Regards

Sanjay

[former_member27647]

Thanks Sanjay for your answer.

I am able to count the days and events but the issue is counting consecutive 7 days. That too, it can be cross-week. That's where I am facing issue.

Regards,