Daily Rolling Forecast

Hi,

I'm trying to set up in my Time Systems module a Daily Rolling Forecast, but having some trouble making it work. I have attached pics of what I have done. Please advice

Thank you

Community_Question_4_88988.PNG

Community_question_5_88988.PNG

Accepted answers

All comments

JLD

Hi @neg177,

Can you try removing the period dimension in your current day? And why is that the current day is a week format?

Jud

neg177

Hi,

By Period Dimension do you mean 'Time Scale'? And I have to have the Format as Time Period/Week because that is the lowest I can do and wont let me use Date as a Format for my function for Actual and Forecast.

JLD

Hello,

By Period Dimension do you mean 'Time Scale'? - Yes the time scale

neg177

That didn't work so well. It just did the following that I have attached in the images. With the formula I have it will not let me change the Time Scale to Not Applicable.

Thank you

Community_question_11_89262.PNG

Community_Question_12_89262.PNG

Quick Links

Can you help?

Unanswered questions

Azure SQL Connection, database name with Hyphens in Data Orchestrator
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
12.4.1 Activity: Create Saved View for Non Employee Expenses
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…