Hi,
I am having a problem with the above function in a straight table. I would like to display the value of the previous row from column (EKPO_BEDAT) in the expression field. I thought this would be possible with the above function.
| EKPO_MATNR_EMLIF | EKPO_BEDAT | EKPO_MATNR | EKPO_EMLIF | EKPO_row_counter | EKPO_counter | Above(EKPO_BEDAT) |
| #-M500D00_ | 29.07.2015 | #-M500D00 | | 135 | 4 | - |
| #-M500D00_ | 29.07.2015 | #-M500D00 | | 136 | 4 | - |
| #-M500D00_ | 29.07.2015 | #-M500D00 | | 137 | 4 | - |
| #-M500D00_ | 29.07.2015 | #-M500D00 | | 154 | 4 | - |
| _ | 21.06.1995 | | | 158 | 12 | - |
| _ | 21.06.1995 | | | 159 | 12 | - |
| _ | 06.02.2003 | | | 37 | 12 | - |
| _ | 04.12.2003 | | | 22 | 12 | - |
| _ | 30.12.2013 | | | 31 | 12 | - |
| _ | 02.01.2014 | | | 32 | 12 | - |
| _ | 28.01.2014 | | | 35 | 12 | - |
| _ | 04.03.2014 | | | 40 | 12 | - |
| _ | 11.05.2014 | | | 48 | 12 | - |
| _ | 20.08.2014 | | | 101 | 12 | - |
| _ | 11.09.2014 | | | 102 | 12 | - |
| _ | 10.04.2015 | | | 153 | 12 | - |
| 1SS01TE2713_ | 29.06.2014 | 1SS01TE2713 | | 55 | 3 | - |
| 1SS01TE2713_ | 30.06.2014 | 1SS01TE2713 | | 54 | 3 | - |
If I only have the EKPO_BEDAT column in the table, the expression is working:
| EKPO_BEDAT | above(EKPO_BEDAT) |
| 21.06.1995 | 19.06.1995 |
| 26.06.1995 | 21.06.1995 |
| 27.06.1995 | 26.06.1995 |
| 28.06.1995 | 27.06.1995 |
| 11.07.1995 | 28.06.1995 |
| 29.01.1996 | 11.07.1995 |
| 30.01.1996 | 29.01.1996 |
| 19.02.1996 | 30.01.1996 |
| 05.03.1996 | 19.02.1996 |
| 13.03.1996 | 05.03.1996 |
| 28.03.1996 | 13.03.1996 |
| 24.04.1996 | 28.03.1996 |
| 26.05.1997 | 24.04.1996 |
| 27.05.1997 | 26.05.1997 |
| 20.07.1998 | 27.05.1997 |
| 28.03.2002 | 20.07.1998 |
| 15.01.2003 | 28.03.2002 |
Any help on how to solve this would be greatly appreciated!
