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.
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…