Skip to Content
avatar image
Former Member

Max Value of attribute depending of date selected SAP HANA

Hi!,

I have a calculation view in HANA and i want to calculate the MAX value of trips by day.

but selecting an specific range of dates for the moment, the Max fuction is doing the same as Sum fuction.

For example:

day 1 9 trips

day 2 5 trips

day 3 6 trips

I need the max value of trips to be 9 in this set of data without the day column. However if i take away de column Days the result gives me 20 with those 3 days selected in a filter. How can i achieve that?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 17, 2016 at 08:02 PM

    Without knowing any further details about your view, my best guess would be that you should consider using the "keep flag" on the day column.

    Best regards

    Ch

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 17, 2016 at 08:15 PM

    Without knowing any further details about your view, my best guess would be that you should consider using the "keep flag" on the day column.

    Best regards

    Ch

    Add comment
    10|10000 characters needed characters exceeded