Dynamic Arrays – Extend the last logical row value in a 2D array
One more for experts. Again, with my new found knowledge I still was not quite able to make this work.
Simple balance sheet values that I need to extend into the forecasts as is. i.e. the last actual value in the row of that block – BUT, the block has several rows each for a different entity and I have an option for have staggered actuals based on the data loaded. i.e. if Entity A has values to 30th Sep 2024 then this is the latest value to carry forward for Entity A. But entity B may only have actuals up to 31st August so I need to take the value for August to carry forward.
I prefer to use flags for the logic. Sample attached
Appreciate the help
One more for experts. Again, with my new found knowledge I still was not quite able to make this work. Simple balance sheet values that I need to extend into the forecasts as is. i.e. the last actual value in the row of that block – BUT, the block has several rows each for a different entity and I have an option for have staggered actuals based on the data loaded. i.e. if Entity A has values to 30th Sep 2024 then this is the latest value to carry forward for Entity A. But entity B may only have actuals up to 31st August so I need to take the value for August to carry forward.I prefer to use flags for the logic. Sample attached Appreciate the help Read More
