Dynamic columns in flex forms
Hi All, Hope you are doing well.
We have a requirement to create a flex form and the same flex form should be used for multiple scenarios ( Forecast, Plan , Long Range Plan) . The Years, Periods should be populated in columns as per the scenario selection.
I'm aware that flex forms columns are static and currently we are trying with Dynamic Calc member to display right columns based on scenario selection which is working upon form open however when we refresh the form , columns are displaying for all years which are in form layout definition (i.e. FcstY1, FcstY2, PlanYear, LRPYear1..5). Example , for Plan scenario it's showing 2023 upon form open , when we refresh, it's showing all other years as well which are related to Forecast/LRP.