-
Returning same value from same Line Item but different items
Hi all, Is it possible to return a value from an item on the same line item? For example, picture this as my module: I want to be able to calculate a delta between S1 and S2 or S3 and S1, like this: Here I'm using SELECT but this will be a lookup since I want the user to be able to select which scenarios he want to…
-
Definitive Current User in a formula
Hi, I have a list of invoices with an approver selected from the user list for each line item, what I want to do is check if the 'current user' is the same as the 'approver' and if so then allow them to write to the item. I have a fake users list, and i can have a module with users with show all set to off, but none of…
-
Current year filter with YTD and YTG
Hello Community, I need a filter in my sys module which should show only current year (this should be FY24). I also need YTD and YTG for this year, i.e current year. I also need a filter for next year. i.e current year +1 and again should be filtered on same year YTD and YTG. Is this possible in Anaplan. Kal
-
Summary module - referencing list with properties
Looking to create a module that provides a summary of a fairly detailed data set that has multiple dimensions, with having originally built this by adding the relevant dimensions to the module and then using a formula similar to the below, just referencing more elements…
-
How to use TimeSum?
Hi! I am new with Anaplan and still learning the functions. May I ask how can I make a summary from a module with time dimension to a module without dimension? Here in the 1st picture is the by field with its actual value, input on a daily basis. Then I have to create a separate summary to show the total actual without…
-
Restrict access to summary items in a line item drop down when using a ragged hierarchy list
Hi, Is it possible to remove the summary items from a drop down list when a line item is formatted with a ragged hierarchy list? Cheers
-
How to make picklist selection user dependent
I have a situation where target lineitem is populated based on the picklist selection. The problem is when multiple users are making the selection, the latest selection is being used. I need this to be dependent on users i.e., one user selection shouldn't affect the other.
-
How to transpose data
I have a module A - Dimension Class and Subject In the module, I have a line item (list formatted) called Order. User will use this module to define Order for each Subject for each class. eg. For Class X; SubA - Order 1 , SubB-Order2 etc. Now I want to create another module dimensions by Class and Order, That can show that…
-
Level 3. Finalize Assignment button in dashboard
Hello, About "Finalize Assignment". There is not much info about this action in training material nor in the community. What does it supposed to do? Thanks,
-
Average Market
Hello, I have a list of 200 companies with all their P&L numbers in a module. Now I want to sum all the data of the 6 biggest of these companies into one artificial company to have a market average. How do I sum the 6 companies that I chose into a company called "benchmark Market" and then compare any single company to…
-
6.6.3 Activity: Add Formulas to Time Settings Module
When i add formula to Current Period Start ..it is not giving any result. Further the Forecast Period? and Forecast Months Only should come as untick. Any help will be appreciated
-
"Unable to Find Workspace Model Data - Check your connection and try again" Issue in Anaplan
Hello Anaplan Community, I am encountering an error message in Anaplan: "Unable to find your workspace Model Data. Check your connection and try again." This issue seems to be related to the connection, but I’m unsure of the exact cause. Has anyone experienced this before? What could be the potential reasons for this…
-
History export fails & unable to view history
Hi All, We are facing one issue that we are unable to export or view history as there is too much entries & error shows time out. Can anyone have any views to resolve same? Thanks Ashutosh
-
Level 1 exam Activity 5
I'm stuck on Level 1 exam model building exam Activity 5. I've spent over 2 hours and I'm frustrated. I've followed these steps and my solution is below with the updated formulas. Can someone offer any suggestions as these updated formulas result in the output being NIL/$0. I'd really appreciate it. And my formulas now…
-
Top Down Approach
Hi All, Check if you can help in the following scenario. I have 2 list PRODUCT & PRODUCT FAMILY (parent of product). Module 1 : (with PRODUCT as dimension) Line item : Check? (Boolean) User will select the product as needed. Module 2: (with product family as dimension) Line item : Check Product Family : ???? (if the…
-
Level3. Commission Forecast
Hello, I have my total target per sales rep yearly as seen below and the numbers does match with ones in the study material: In the Commission forecast I am using monthvalue formula to compute the commission forecast but the numbers are not showing up. Please advise: P.S I have tried quartervalue also and it didn't work.…
-
Data not pulling in Dashboard from dource module
We have a problem. About us - we have a smaal-medium size model of about 23GB with about 200 users. We operate arou d 50 or so Business Units rolling up through Divisonal and Group structure Most User interaction is through Dashboard (though there is a fair amount of Excel Add-In reporting) which has DCA locking applied. A…
-
Level 2 Model exercise
Hi team. what is the formula to be applied for line item Has Data? in the spring 1 exercise 1.5.7.2 Add Formula to SYS13 Line Item the hint is not helpful regards, Baskar
-
Level3. Account Territory
Hello, I am using SYS07 to load territory data in QUO07. I understand that they have different dimension however, Anaplan accepted the reference but not showing the info. any hint how can I solve it? SYS07 QUO07 Thanks.
-
Level3. Net Commission%
Hello, Can you please guild me what does "Net Commission%" represents? Thanks,