-
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,
-
how can i do it ?
Module dimensions : time , lines , zone Goal : display lines following this rule
-
集計
製品の工場での生産データがあり、それを製品ごとに、各工場では何個生産したか集計した表を作りたいです。どうすればいいでしょうか。3つの工場で生産があるものについては、TRUEとしたいのです。
-
Error while updating formula for REV05 unit %
HI There, While updating the formula for REV05,I am getting the following error. Can anyone help me out. 'REV04 Price Growth Rates'.Unit Price%[LOOKUP: 'SYS04 Location Details'.Country, LOOKUP: 'SYS06 Product Details'.Product family]
-
Level 3. QUO06 Tenure Calculation
Hello, Can you please review my formulas here: i am not sure why I see 5+ years here for everyone: Thanks,
-
Help needed to get the data by pulling from two time scales
Hi, i want to get volume data based on the line item 2 to my target module which is at year level. But my source having the time dimension while i am writing the formula no values are coming
-
明細データの合計
下記のようなデータで、Flgの合計が1以上ならXのような式を作りたいのですが、どうすればいいでしょうか