Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Displaying minimum date value for each row

Hi,

I am trying to create a webi report. The report has  the following fields. Data in the database is also in this form.

Vendor No
Name
Changed Date
Status
100abc6/24/09N
100abc6/28/13Y
100abc7/2/13Y
100abc9/11/13N
100abc12/1/14Y

The requirement is to replace the Changed date column with a variable(New Changed Date) that will show the minimum date value for each status. this means that when there are same status in two consecutive rows for a particular vendor number, it will display only one row with the minimum date. For example, here there are two consecutive rows for Y status with different dates. The column will show only the minimum date from the two rows of Y status and when there are no consecutive occurrence of the same status then it will display the date as it is.

The below table will be  the required output.

Vendor No
Name
New Changed Date
Status
100abc6/24/09N
100abc6/28/13Y
100abc9/11/13N
100abc12/1/14Y

Please help me with a formula that can give the desired output in Webi. I am using BO XI R3.1

Regards,

Argha

Tags:
Former Member
replied

Hello Argha ,

As mentioned by @Jonathan Brown,

You can use =If ([status] = Previous([status])) Then  "1" else "0" as a variable "v_filter "


Then put a Block filter and apply v_filter =0.

This will remove the record which is having repeated Status .

Hope the date will be in Ascending order .

Please try and let me know .

Regards

Arjun KT

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question