Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Future Consideration
Workspace Jedox Platform
Categories Web Spreadsheet
Created by Guest
Created on Feb 18, 2025

Annual Splashing in Forecasts

There should be a simplified method for annual data splashing in forecasts without altering the actual periods while still achieving the target value. Currently, when data is splashed on an annual basis and actuals from previous periods are copied, it does not yield the desired target value.

My Suggestions:

  1. Develop a splash command that first deducts the actual monthly figures from the annual total (including values copied through rules) and then distributes the remainder across the planned periods.

  2. Create a procedure with the hold manager that allows for the simplified locking of previous periods in the forecasts, enabling the annual values to be allocated to the planned months effectively.

Forecasts are increasingly being requested in the future, so it would be beneficial to enhance the annual data splashing process.

Thank you very much for your feedback.