- OneStream Community
- Forums
- Rules
- calculate QTD data to overwrite system generated number.
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
calculate QTD data to overwrite system generated number.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2024 06:09 PM
Hello Community -
Looking for guidance on options to calculate data at QTD to overwrite the number generated from periodic values.
This intersection has an option for users to enter periodic values, so I cannot make a member dynamic calc.
I am using UD8 dimension member for the calc. Please share your thoughts.
Thanks!
- Labels:
-
Finance
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-07-2024 09:59 AM
Can this be achieved by Formula Pass or Finance business rule?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-07-2024 10:34 AM
The QTD member is input so that data can be entered quarterly and then allocated to the dependent periods. I think the only way you can achieve this is to have an adjustment member for the QTD value. If you consider YTD rather than QTD, if you set a value as YTD, the system adjusts the periodic values so they aggregate correctly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-07-2024 12:05 PM
Need to run calculation at QTD to replace the data coming from Periodic entries, can this be achieved by making the UD8 member as Formula Pass so that periodic can be open for input and QTD number calculated.
