Hi devs,
Trying to update the Value column with the highest value for the product by looking into the rows between the flag 1 and -1 in the edit script. I managed to get the output in the front end using above and below functions but I would like to do this in the edit script.
*Result for the row with flag value -1 should be blank - as seen in the expected result column
Sample data laid out below and the expected result.
| rowno | Product | flag | Value | | Result |
| 1 | 101 | 1 | 1 | | 4 |
| 2 | 101 | 1 | 4 | | 4 |
| 3 | 101 | -1 | 8 | | |
| 4 | 101 | 1 | 10 | | 10 |
| 5 | 101 | 1 | 2 | | 10 |
| 6 | 101 | 1 | 3 | | 10 |
| 7 | 101 | -1 | 1 | | |
| 8 | 101 | 1 | 9 | | 15 |
| 9 | 101 | 1 | 6 | | 15 |
| 10 | 101 | 1 | 10 | | 15 |
| 11 | 101 | 1 | 15 | | 15 |
