10-03-2023 04:54 AM - edited 10-03-2023 05:00 AM
Hi,
I am working on the cubeview below, where I have 2 dynamic calc accounts. On some of the cells their value is greyed out. The dimension on column is UD4. Can somebody help me understand why some of the values are greyed out? Thank you
Solved! Go to Solution.
10-03-2023 06:03 AM
Right click on the cell and select Cell Status. That should indicate how that data was obtained, and as @TimVierhout said, a grey value is typically derived. It's hard to say more without seeing the Account settings, the Scenario settings, and the calc formula.
10-03-2023 05:26 AM
In general with the default formatting this means this is derived data.
10-03-2023 06:03 AM
Right click on the cell and select Cell Status. That should indicate how that data was obtained, and as @TimVierhout said, a grey value is typically derived. It's hard to say more without seeing the Account settings, the Scenario settings, and the calc formula.
10-03-2023 06:41 AM
Thank you both. If I right click on the grey values I can see their status is Derived=True. After some investigation I found out that the source values to which the dynamic formula refers are also derived when the dynamically calculated account shows grey values.