Skip to Content

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

End time calculation based on date SAP BEx


Hi gurus,

             I have a scenario where I have an info object 'End Time' which has to be calculated as the maximum value based on a date and another field which is unique. End time is already set to Aggregation 'Maximum' in rsa1 in the backend.

Please see the sample data below:

Steps      Unique ID                 End time     End date

S1              UID1                     00:07:32    29-Dec-2014

S2              UID1                     00:12:45    29-Dec-2014

S3              UID1                     00:05:06    29-Dec-2014

S4              UID1                     00:09:10    29-Dec-2014

I require the output to be :

Steps     Unique ID     End time     End date

S2             UID1           00:12:45     29-Dec-2014

Constraint:

Unique ID and End date cannot be obtained from a variable.

Can you please help me calculate this value in SAP BEx Query Designer?

Thanks.

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