Carry forward a value over several months

Hello fellow Anaplanners,

I'm working on a module that has an Approved FTE by month. But the user can go adjust it through a form and add/subract FTEs as needed. It is working great for the current month. Meaning( Mar 2023 has 2 FTE for Job A. User adds 1 more for Mar 2023. I have a Final FTE line item that sums the 2 and gives correct result as 3 FTE for Mar 2023)

Now I would like it to continue as 3 FTE in all future months. I've tried all sorts of ways but just can't get it to stick.

Any thoughts?

*PRF stands for Personnel Request form. APP FTE at top is the initial budget. APP - PRF is the change that comes from UX. Final APP PRF is a sum.

Accepted answers

BrunoRodriguez

Hello @DeepakK,

I am not entirely sure I have understood the requirement because I am reading 3 and seeing 1.9 in the image. However, I have created the following which hopefully can help you getting to your goal:

where:

APP FTE = 0.9
APP - PRF (manually input) : Monthly input whenever there are changes, if not the value gets carried forward.
Final - PRF : IF 'APP - PRF (manually input)' <> 0 THEN 'APP - PRF (manually input)' ELSE IF Control <> 0 THEN Control ELSE 'APP - PRF (manually input)'
Final - APP PRF = APP FTE + 'Final - PRF'
Control: IF PREVIOUS('APP - PRF (manually input)') = 0 THEN PREVIOUS(Control) ELSE PREVIOUS('APP - PRF (manually input)')

Please let me know if that is not helpful!

Cheers!

All comments

BrunoRodriguez

Hello @DeepakK,

I am not entirely sure I have understood the requirement because I am reading 3 and seeing 1.9 in the image. However, I have created the following which hopefully can help you getting to your goal:

where:

APP FTE = 0.9
APP - PRF (manually input) : Monthly input whenever there are changes, if not the value gets carried forward.
Final - PRF : IF 'APP - PRF (manually input)' <> 0 THEN 'APP - PRF (manually input)' ELSE IF Control <> 0 THEN Control ELSE 'APP - PRF (manually input)'
Final - APP PRF = APP FTE + 'Final - PRF'
Control: IF PREVIOUS('APP - PRF (manually input)') = 0 THEN PREVIOUS(Control) ELSE PREVIOUS('APP - PRF (manually input)')

Please let me know if that is not helpful!

Cheers!

Sai_Bharadwaj_Venati

@DeepakK

U can adjust your Final APP PRF formula like this if you're working on Budgeting Scenario : -

IF Actual Months then Actual Months Final APP PRF ELSE IF APP PRF <> 0 and Budget Starting Month then APP FTE + APP - PRF Else Previous(Final APP PRF) + APP - PRF

DeepakK

Sorry, I had to work on some other client requirements. Just tried this out today.

@BrunoRodriguez Your solution works really well. Thanks! Now the issue I'm facing is if the user makes another adjustment down the line. The numbers don't come together and keep adding up later on.

DeepakK

@Sai_Bharadwaj_Venati

Thanks for the info. I will try this and let you know. Not sure if I need this now. I don't set up versions in this model.

BrunoRodriguez

Hello @DeepakK ,

Happy to help.

If that is the issue you can always try a cumulate or LI + previous for the last item.

Cheers!

DeepakK

Thank you both. These solutions worked and I was able to get a carry forward. Appreciate it.

Powell69

@BrunoRodriguez Thank You.

Quick Links

Can you help?

Unanswered questions

How to use the API Key？
Hi all, A generated API Key is available, intended for uploading and importing files. Could anyone share how to use it to make requests? Is there any prior setup or authorization required before the API Key can be used? Any guidance, examples, or tips would be much appreciated.
12_ [COMPLETE GUIDE] Uphold Support Number
At Uphold customer support ⭐+1-888-355-2348 accounts may be temporarily disabled or restricted for various reasons. Raise a concern on priority basis at Uphold support ⭐+1-888-355-2348 if you notice any suspected malicious activity, or a problem during account recovery. To contact Uphold support directly at…
New UX Filtering for Hierarchy sibling
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…