Hi,
In a module I had a list (A1,A2,A3,A4) and a line items Value,type(list formated line item),change value
if two list items has same type and status as inactive then change value for inactive list item should get active list item value
EX:
| value | Type | Status | Change value |
A1 | 145 | TypeA | Active | |
A2 | 124 | TypeA | Inactive | 145 |
B1 | 173 | TypeB | Active | |
C1 | 122 | TypeC | Active | |