08-27-2024 04:33 PM
Hello Community,
I have an issue, hopefully someone has a solution.
I started with this article:
https://blackdiamondadvisory.com/library/breaking-up-is-easy/
to try to get a grid/chart that some users want.
My problem is I’m trying to get it set up for so for the current year it shows two rows, one for Actual and one for Forecast, but only shows data for actual up to a selected period and only shows forecast for the periods after the selected cut off. I’m trying to do that by selecting the U8# of “data” or “None”
Here’s what my rows look like:
Here’s my column as it pertains to these two rows (using overrides for the prior year rows, which work fine)
Here’s the function which I think is working,
The issue is trying to pass the scenario in my XFBR. Everything I tried is passing “Actual”. I tried CVScenario, PovScenario, MFScenario (this one failed). How do pass the specific cell or row’s scenario for consideration in a column CubeViewHelper depending on which row is being evaluated?
Thanks for any guidance that can be provided.