Skip to Content

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

Alert based on a value of previous row

Hello there

On a db level there are analytical functions 'LOG' which allows to compare the previous value, but my task is to create the alerter which sends e-mail if next value is greater than current one.

I know that there is a functions previous() etc, but how to implement this, maybe smb can elighten me on this.

Example:

ID      DATE           TRANSACTION COUNT

1     01.01.2014         1120

2     02.01.2014         1099

3     03.01.2014         1700 --> Alert is triggered

SO, for the last value alert has to be triggered and sent to E-mail. On DB level i see no problems implementing this, but how to implement this in Crystal?

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