I'm working on a different formula in the same module. Let me know if I should move this to a different post but it's related so I'm posting here.
I have three line items - 3% Escalation, Manual Input, Final.
The 3% Escalation is the formula you assisted with earlier. The Manual Input line is to enter a different number if we don't want to use the 3% escalation. The Final Line item is where it picks one or the other.
I need some assistance in figuring out the Final Formula for the forecast years.
For FY 2020 - We only want to use the Input Line.
For FY 2021 and FY 2022 - We want the formula to default to using 3% escalation unless the Input line is populated or we have identified that that item should be projected at $0.
Is there any other way to incorporate this without having to setup a boolean for which line items we want to leave at $0 vs. which ones we want to use 3% vs. which ones to use manual input?
The reason we would want to leave certain line items at $0 is because they only occurred once or twice a year so no trends.
Here are the screenshots for the formula that I have been attempting but it is not accomplishing the results I would like to see:
Here is a screenshot of how I would like to see the results:
Thank you for your help. I agree that building out the System Modules would be the right step but we are in a time crunch and I may not have the time and resources to complete that at this time. Therefore I was looking for a formula I could apply to the existing module.
I look forward to connecting with you soon. Thanks for your help.