-
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…
-
YTD / YTG Functions
Hi All, Looking for a bit of guidance here, around YTD / YTG functionality, do people tend to use the elements that are shown in the model calendar, or do they do in a different manner and if so how? I would appreciate any guidance and pro's / cons that people could advise. For reference, we don't use native versions,…
-
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
-
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,
-
Numbered list ?
I am unable to get this right i am getting this but the correct one must be
-
明細データの合計
下記のようなデータで、Flgの合計が1以上ならXのような式を作りたいのですが、どうすればいいでしょうか
-
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…
-
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.
-
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 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…
-
Can a List be Copied similar like Modules?
Dear Community, I have a basic question, many will feel it might be silly but still need to ask whether we can create a copy of the lists available in the General list sections like modules? If NO then why & if YES then how can we do it? Hoping to get answered by anyone of you soon!!! Regards,
-
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…
-
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…
-
How to import date from one model to another
I'm not sure if there was a new update that changed the process? I cannot import a date from one model to another. I am trying to import the dates from A01 to A06. I think the checkbox on the mapping page is new. I've tried different variations but can't seem to get it to work. Thanks in advance
-
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.…
-
Commission calculation
Hi, Can anyone tell me whether the below calculation is correct or not? If yes, then can someone please clarify why the quarterly balances are different Thanks AB
-
Sales rep monthly Commission not matching with Anaplan 'Check Your Build' numbers?
Hi All Community Members, Despite putting a lot of thought and efforts, I am not able to figure out where am I going wrong. I have set all the Modules and formulae in place but still the numbers for the sales rep monthly commission is not matching with the Check Your Build numbers. Please find below details of my modules I…
-
PlanIQ Error
Hi, Do you know what would cause a 'PlanIQ Flow Trigger Failed' error @Misbah
-
Help on circular reference with POST
Hello, Do you know if it's possible to force the formula POST like LAG with STRICT argument. My use case to be able to POST value in the future for stock equation. If I use LAG(value , Leadtime , STRICT) or POST(value, 2) the formula are ok If I use POST(value, Leadtime), I have a circular reference. So I try to help using…
-
how can i do it ?
Module dimensions : time , lines , zone Goal : display lines following this rule
-
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…
-
Error - Array index out of bounds
Hi, I have a OUTPUT module that has 10 line items - I made a LISS out them and created a SYSTEM module with the LISS as a dimension in order to map the LISS to a list. I then go back to the the OUTPUT module and reference a CALC module for a number, and do a LOOKUP on the SYSTEM module. This works for all line items except…
-
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
-
Level 3 : QUO06 Module & Sales Reps Flat# list not used !
Hello Anaplan Community, I have completed Sprint 1 and Sprint 2 of the Level 3 training, and all my answers were correct (they matched the answers provided in the Check Your Build section). However, I did not use the QUO06 Tenure Calculation module and the Sales Reps Flat# list that were prebuilt in the model by Anaplan.…
-
集計
製品の工場での生産データがあり、それを製品ごとに、各工場では何個生産したか集計した表を作りたいです。どうすればいいでしょうか。3つの工場で生産があるものについては、TRUEとしたいのです。
-
"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…
-
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…
-
Level 1 11.3.4
Hi, Even if I enter the formula as instructed, The sample and answer are different. Any help is appreciated. Thanks. This is my model: This is the should be:
-
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.