Forum Discussion

AndreaF's avatar
AndreaF
Contributor III
2 years ago

Why are some values greyed out?

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

 

 

Cube View
  • JackLacava's avatar
    JackLacava
    2 years ago

    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.

  • TimVierhout's avatar
    TimVierhout
    New Contributor III
    2 years ago

    In general with the default formatting this means this is derived data.

  • JackLacava's avatar
    JackLacava
    Honored Contributor
    2 years ago

    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.

  • AndreaF's avatar
    AndreaF
    Contributor III
    2 years ago

    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.