The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Justin_Zurn's avatar
Justin_Zurn
New Contributor
2 months ago

Orders calculation formula using Backlog and Sales Accounts

Hello, I'm attempting to create an orders (500055) account, calculated using existing Backlog (500054) and Sales (100020) Accounts.   (Current Month Backlog - Prior Month Backlog + Current Month Sa...
Admin
Finance
System
rhankey's avatar
rhankey
Contributor III
2 months ago

You don't specify what is occurring with the M1 logic.

I would start by replacing the T#PovYearM1 on the destination side with T#POV, as though this Calculate() is being run for M1, OS isn't usually happy if it thinks you could be attemptingto write to a different DataUnit than you are currently in.

Beyond that, you're going to need to provide a little more clues as to what is occurring with the M1 logic.

  • Justin_Zurn's avatar
    Justin_Zurn
    New Contributor
    2 months ago

    Thanks for reviewing rhankey,

    For M1, it appears as if the Prior Year Backlog portion of the formula is being left out.

    " - A#500054:T#PovPriorYearM12:O#top:U1#top:U2#top:U5#top:U6#top)"

    Unsure of the cause at this point.  Will continue to troubleshoot.

     

    Thank you,

    Justin Trad