-
Converting numbers to text without losing decimals
Hi! I am trying to create a reporting module with mixed line items (numbers and percentages) so I am converting the numbers to text for display purposes only. We need 1 decimal and have very small numbers eg. 0.0001 which should then be displayed as 0.0 however during the process the decimal is lost. Same issue with…
-
display name not referencing module line item
Hi Anaplan community, I've been trying to give a name to the numbered list with a formula but is not working. Can you please assist? The source module only applies to this list.
-
Scenario Planning.
Hi, I need some help in building a scenario model. For example, In the P&L report, there are 2 scenarios the user can switch. In what-if scenario 1 user can update the Unit price/Unit cost and the changes will reflect in Revenue and COGS. And in what if Scenario 2 User gets to change the volume and changes reflects in Rev…
-
Can Anaplan read data past model calendar?
I used the PERIOD function to fill in the dates for a filter I am using in Month LU line item. But Anaplan isn't reading any dates past 2025. Model calendar ends 2024, is that why?
-
How to look up prior year values
I want to lookup for previous year March values. For example if my current month is june FY24, then i want to lookup for March FY23 Values.. how can i make this lookup.
-
Converting Data within module
Hi I have data in below format. I am expecting to create a new module with below dimension and structure. Could you please suggest an efficient way for the same? Thank you
-
Copy a value (year dimension) to a Monthly dimension module and Version dimensions
Hi, We are struggling to find a way to get our "Bill Of Materials" in Anaplan. I would like to enter values for a Bill Of Material for our products with a year dimension. The consumption of the raw materials is valid for the whole year. Furthermore the Bill of Material is valid for all Custom Versions: Below is the idea…
-
How to access the latest value for an item in an archival list?
Hi All, I have an archival list where after each month's data upload into anaplan the old months entries gets dumped into. And now for 1 requirement I have to pull one of the item from the list having last months value. i.e. the value just before the monthly upload. The Item that I am trying to pull has text format. Also…
-
Scenario Planning.
I'm looking for scenario planning model building. Can anyone point me to a learning tutorial?
-
Zero in number formatted line item in beginning
How to have a number formatted line item starting with zeros? Eg. it should have a value like 0124 or 0001324?
-
Link 2 data sets
Hi We have a module with multiple relationships, like manager to employee relationship and employee to office relationship. The end goal is to have 1 line item with all 3 (manager, employee and office) in 1 line item. We created 2 modules from the parent module as below Module Mgr-Emp Rel List "Rel" Rel 1 Mgr1 Emp1 Rel 2…
-
Can someone help explain what is the difference between a fake version list and native lists?
-
Chart labels for multiple line item/version combination
I want to set up a line chart that shows 2 line items and 2 versions (4 total lines): The chart works fine but the labels at the bottom only show the line items, not the versions: Is there a way to show both the line items and the versions in the table?
-
Restrict access to edit existing line items but allow to write new entries (DCA?)
Hello! My company tracks hundreds of different rates. Our procurement team uses an Anaplan upload to import these rates into the system. An example of what they upload could be something along the lines of Vendor Name, City, Rate. The procurement team then has a UX page where they can update the rate if it changes for any…
-
Personalized calendar : the hijri calendar
Hello, I have a question and I would greatly appreciate your assistance. I am interested in creating a Hijri calendar using Anaplan. The reason for this is that my product follows a seasonality pattern that is usually influenced by the events of the Hijri calendar, which is also known as the lunar calendar. I would like to…
-
Build a model in Anaplan with a specific hierarchy
Hi,I am currently working on building a model in Anaplan with a specific hierarchy. The hierarchy includes the following levels: Department (Level 1): Departments A, B, ..., F. Production Line (Level 2): Production lines 1, 2, ..., 8. Type of Line (Level 3): Types "S" and "W". Product (Level 4): Products list . The desired…
-
Why can not close a dashboard in Anaplan?
One end user can not close the dashboard in Anaplan and get above warning. But on other dashboard did not meet such issue. What happened on it? Please advise.
-
what would be the formula for referring Previous year value in current year ?
For example, I want to refer the value of last year july 2022 in current month July 23. the line item is Past year revenue where I just want to show same month revenue from previous year, how could I achieve that?
-
what would be the formula for referring Previous year value in current year ?
For example, I want to refer the value of last year july 2022 in current month July 23. the line item is Past year revenue where I just want to show same month revenue from previous year, how could I achieve that?
-
Versions in the new UX
So I'm creating a page in the new UX, essentially trying to display Actual and Budgeted amounts for a period. I'm intending to have the Actuals and Budgeted amounts shown as columns and the different categories as rows. I also want to show the variance between these two versions on the same column axis as the versions…