1 of 1 people found this helpful
This should do it for you.
[Year] in the sample dataset is an integer not a date. If it is a date in your real dataset then you will need to adjust the formula as required.
IF ATTR([Year]) = 2017 THEN SUM([G])
ELSEIF ATTR([Year]) > 2017 THEN PREVIOUS_VALUE(SUM([C]))-(PREVIOUS_VALUE(1)*SUM([B]))+SUM([F])
Hope this helps.
Amazing thanks a lot Okechukwu
You're welcome Benedict. Glad it helped.