We know that Oracle Planning supports dynamic time series functions like YTD, QTD, etc. I’m wondering if there are similar built-in functions for “to go” calculations, such as YTG (Year-to-Go), QTG, or MTG?
The client is working on sales forecasting and would like to use dynamic time series functions for "to go" periods, similar to how it works for "to date" periods. The YTG(period) will be used in forms to show sales data and some percentage data. Their forecast is done as low as the daily level, so hard-coding these calculations would be impractical.
Are there any recommended approaches or features in Oracle Planning to handle this scenario easily?
Many thanks!