Skip to Content
0
Feb 08, 2022 at 12:16 PM

Update FTE in SAC Planning

286 Views Last edit Feb 08, 2022 at 09:12 PM 2 rev

Dear Team,

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.

image.png

I have tried with data action but not succeeded with all condition. Please suggest.

Thanks!

Attachments

image.png (21.7 kB)