Displaying minimum date value for each row
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|
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|
Please help me with a formula that can give the desired output in Webi. I am using BO XI R3.1
Arjun K T 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 .