IF 'SYS09 Version Details'.Forecast? THEN 'EMP02 Employee Expenses'.Employed?[SUM:'SYS08 Employee Details'.Country] ELSE 'DATA01 P&L Actual and Budget'.Head Count+'DATA01 P&L Actual and Budget'.Head Count
@mahendra7
Not sure if you are following the learning activities properly, formula here should be
IF 'SYS09 Version Details'.Forecast? THEN 'EMP02 Employee Expenses'.Headcount[SUM: 'SYS08 Employee Details'.Country] ELSE 'DATA01 P&L Actual and Budget'.Headcount
Would someone kindly assist with helping me identify the errors with the following perimeters I have set?
I’m trying to understand how Anaplan Data Orchestrator (ADO) connects to an on-premises SQL Server. In Anapedia, I found this: An MSSQL instance hosted on a cloud platform, such as Amazon Web Services (AWS), Azure, Google Cloud Platform (GCP), or any other cloud provider. The solution is compatible with on-premises SQL…
Title: How to get most recent actual year value into a non-time (staging) module and use it for forecast calculations? Question Body: Hello Anaplan Community, I am working on a financial model (Higher-Ed long-range planning) and need guidance on a best-practice pattern to retrieve the most recent actual year value and use…