i m trying for Default Forecast and also with Round formula..I m confused about the formula. Can somebody help for this ?? I got the Baseline Forecast and Growth Rate%
@Sagar123 Here is the Anaplan technical documentation for the Round function.
ROUND - Anaplan Technical Documentation
If you're trying to round your Default Forecast line item, best practice would be to calculate the Default Forecast = 'Baseline Forecast' * 'Growth rate %', then have an additional line item like 'Rounded Default Forecast' = ROUND(Default Forecast). You can add the additional arguments to the Round function as necessary according to the technical documentation.
Thank u Sir for helping. I got my answer. Demand Forecast formula needed (1+Growth rate %)* Baseline Forecast and Round off was pretty simple.
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…
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
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.…