Skip to Content

Webi Need Max date across multiple rows?

Hello All,

Below is my raw data in Webi and I am looking for formula which will return each employee with latest date. The tried various different ways but what it returns the max date from the whole data set.

Any help is appreciated!

Thank You.

capture.jpg (30.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 26, 2017 at 07:54 PM

    use this.

    =max(date) in (employee)

    Or create variable and filter on to get the max date row.

    Var=if(date=max(date) in (employee)) then "show" else "hide"

    Apply filter on Var equal to show

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 26, 2017 at 08:16 PM

    Thanks Amit I am already doing this using

    =If(Max([Date]) In ([Employee]) = [Date]) Then 1 Else 0

    But it returns only E3 01/06/2016

    Add comment
    10|10000 characters needed characters exceeded

    • no it's wrong.

      follow these steps.

      V Date=ToDate([Date];"MM/dd/yyyy")

      V Date is now with date data type.If you will use Formatdate function then it will convert to string datatype.

      =If(Max([V Date]) In ([Employee]) = [V Date]) Then 1 Else 0

  • Apr 27, 2017 at 03:45 PM

    With Help of Amit Kumar I followed the steps and only change I did was I was using Employee Name

    If(Max([V Date]) In ([Employee NAME]) = [V Date]) Then 1 Else 0

    Instead I converted the date to Todate first V Date=ToDate([Date];"MM/dd/yyyy") and then

    =If(Max([V Date]) In ([Employee ID]) = [V Date]) Then 1 Else 0

    Worked like a charm!

    Add comment
    10|10000 characters needed characters exceeded