How to carry forward my field value till the current date?
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 !
