Skip to Content
avatar image
Former Member

Show length inbetween double with condition


After doing some research (in which I didn't find what I was looking for) I've decided to ask my question right here.

I have a DataBase containing Users. These users have ID. To these users it might happen some event (sickness, vacation, ...) which have a starting and an ending date.

However, in some cases, an event ending date can change. For example in case of sickness, someone who is supposed to be sick 2 days, but in fact it goes wrong and he won't be able to come back until 1 week. In these case, here is what I have in my request :
ID : AAA --- Start : 01/01/2016 --- End : 02/01/2016
ID : AAA --- Start : 01/01/2016 --- End : 08/01/2016

And when I want to know, how many days this user with this ID was away, I'll just summ all of the line, and he will counted as 2 + 7 days, instead of only 7 days.

In this example, it only appear once but an event ending date can move multiple time, if he break his leg when he's sick for example, another line will appear :

ID : AAA --- Start : 01/01/2016 --- End : 25/01/2016

Then, I want to find a solution for the problem :
-We seek in the event list when the ID and Start Date are the same. When this is the case, we seek the one with the most distant Ending Date: in this line we write the length of the time away, in the other one we write 0. And we do this for everytime we see at least 2 line with the same ID and Start Date.
-For the other Event in which ID and Start Date only occur once, we write the length in the line.

I know the idea, but I don't know how to do it on BO.

Thank you for your help and sorry for any mistake I made, English isn't my main language.

Add comment
10|10000 characters needed characters exceeded

  • you posted with a wrong tag, I removed SAP Forum and used your secondary tag as new primary tag

    SAP Forum is an SAP event, see here a blog from such an event: , using this tag people can talk about this event. Your question is not related to this event.

    Please use tags that reflects your working area

    Kindly post with the most relevant primary tag to get the attention of the right experts who can help. Posting with wrong tags adds just garbage to the activity stream of the people who follow this tag. Without the proper tag, the right people will not see your question and those that do see are not likely be able to provide a solution.

    You can find the list of primary tags here:

  • Get RSS Feed

0 Answers