Hi,
I have a field 'Remaining' which is calculated based on the difference of 'Requirement - Obtained'. I have another field 'Status' which has two types of values (Open and Closed).
If my status is open, I need to carry forward my 'Remaining' value from the particular month till the current date (Today) till the status for the ProdKey is 'Closed'. For example:
| ProdKey | Month Year | Required | Obtained | Remaining |
|---|
| 14 | Jan 2018 | 5 | 3 | 0 |
| 14 | Feb 2018 | | | 2 |
| 14 | Mar 2018 | | | 2 |
| 14 | Apr 2018 | | | 2 |
| 14 | May 2018 | | | 2 |
| 14 | Jun 2018 | | | 2 |
Here, My status is open, So my value in the field 'Remaining' carry forwards till the current month year. i.e 5 - 3 = 2 value is carried over to the next month and it goes on till the current month year which is 'Jun 2018' (Today). Now i need an expression to perform this logic. Please help !
