Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
May be try with TOTAL
Above(TOTAL EKPO_BEDATExpression)
Great, thanks for the help, that worked!
Good learning ![]()