I have FTE data in my planning report and 3 columns FTE, FTE adjustment and New FTE. I need to update FTE column through New FTE column. Calculation is already applied on New FTE= FTE+FTE-Adjustment. My requirement is based on fte_adjustment, if I add 10 in FTE_Adjustment P4 then New FTE should be 911 and FTE P5 should be updated with 911 as well. And all other periods data should also be updated with 10. If I add 10 FTE in P7 then it should be update in New FTE column and P8 FTE and respectively in all other periods as well.
I have tried with data action but not succeeded with all condition. Please suggest.