Forum Discussion

Brooks's avatar
Brooks
New Contributor III
6 hours ago

Derived Values Consolidating

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.

 

    • Brooks's avatar
      Brooks
      New Contributor III

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