Derived Values Consolidating

Question

I'm having an issue in which derived YTD values are consolidating in their period and it is throwing off our results. In the example below which shows expenses by department for a site, there are no longer expenses for the Mfg_Selling dept in M2. OneStream calculates the derived YTD values of -37905 (0 - the prior period expense of 37905). This I understand. What I don't understand is why that value is consolidating up the hierarchy when the view is set to periodic. NOTE: I know how to hide the derived value in Mfg_Selling/M2, it is shown here for illustrative purposes.

&nbsp;

T_Kress · Answer

This is likely due to a combination of your scenario properties and settings.
This is a good post that should help you understand: &nbsp;Making sense of the Scenario settings | OneStream Community
To help you solve this, we would need to answer several questions:

view of cube view above
all the various scenario property settings

&nbsp;
&nbsp;

Brooks · Answer

Thank you. I did read the blog post before submitting, but for a newbie like me, it still left me with some questions.&nbsp; Is my problem the Retain Next Period setting?&nbsp; I can also get screenshots of the CV settings, but that will take several replies.

Forum Discussion

Derived Values Consolidating

Related Content

Consolidation

Derive account based on Data Value in Transformation Rules.

Derivative rules

Question: Is there any documentation to help in discussing calculated/derived values showing grey/black values?

Derivative logical operator issue