Skip to Content

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

First Value based on History Timestamp

Hello all,

I'm looking for some way how to create variable, which shows me only first value based on history timestamp. To be more exact... I have history fields in my report and some numeric values. Firstly, I've created variable running count - based on history timestamp, which give me # 1 to first value. Then I need to create new variable, which shows me value, where running count is 1 - for each ID (I have duplicate IDs in my report and therefore I want to see this #1 value in each record). I've used several options already, but unfortunately none of them was working 100% correctly. Don't you have an idea how could I solve my problem?

Btw. To use filter is not sufficient for me - I need this variable for further analysis.

Thanks in advance


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