Skip to Content
0
Jul 27, 2016 at 11:36 AM

Relative Date function

2514 Views

I am using Webi 4 Business Objects I have a detailed variable called Start Date:Absence which may not always be populated, depending if the person is on maternity leave. I also have a field called Level2:Structure which contains either 31NB or 31NI. These represent business units and will always have one or the other populated for each person. I want to be create a new dimension in a new column of the report that will look at the Start Date:Absence field if it contains a date and if the business unit is 31NB it will populate the new column with a date which should be the Start Date:Absence result plus 126 days. If the business unit is 31NI and there is a date in the Start Date:Absence field then it should populate the new column with a date which should be the Start Date:Absence result plus 98 days. Can anyone help with the formula I need to use? Many thanks Will