-
Quarter Boolean to check off at the last month of the quarter
Hello, I currently have a Boolean that is manually checked. It is selected at the quarter level. How could I get it to check off another boolean that is monthly? I would like it to check off at the last month of the quarter. Please let me know if this is clear. Thanks
-
Tell us your thoughts on ALM via a short survey!
Customers and Partners, Please take this short survey, which should take you less than 10 minutes to complete, to tell us your thoughts about ALM. Thank you, User Experience Research Team
-
Community perspective: Anaplan user license management
What is an Anaplan user license? Users get access to Anaplan based on the model role provided to that user. From an Anaplan commercial perspective, each Anaplan user is consuming one active Anaplan user license. On a high level, Anaplan has the following three types of user licenses: * Model builder * Contributor * Viewer…
-
L1 Question 6, getting 0s
Hello, I have entered the following formula and I'm getting zeros on the Employee Expense Summary. Any ideas?
-
Breakdown by proportional division
Hi, I want to use breakdown function. Breakdown has equal division function as default. (Image is Adjust(normal)) But I want to breakdown by History rate. case) Japan : 1000 * (200/800) = 250 Are there any way to achieve this by using breakdown function?
-
Write Access Driver to Parent Item
Hi, I want to use breakback function and Write Access Driver. We have Country List which has Region List as Parent. And Users input to "Adjust Lineitem" and it set as breakback. In this table, I want to users can write "Adjust" by Region List, and cannnot write by Country List. I want to set a Boolean Lineitem to Write…
-
Converting inputted Date Range into new monthly module
Hey all, I need some advice here. I have a module (no time scale) where one of the attributes of a project is the start and end date (manual input as a date). I want to populate a new module (monthly time scale) with a 1 for each month the project will be active. Any recommendations on a formula to use to do this? Example:…
-
Filtering and UX
Hi all, Here is my situation: I got a module (REP_01G) to calculate Version Variance, this module has other dimensions such GL, Project, Currency, Company, and Time scale is Month. And a list of line items as shown below: Reports with Time and Line Items on column will be build. The row could be project, GL, or company,…
-
Provide your thoughts on Anaplan's Excel add-in
We are looking for Anaplan Analysts and Report Builders to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of…
-
Community perspective: Central User Access Management
What is Central User Access Management? "Central User Access Management" is an Anaplan model through which we can maintain user access management for all the models within an enterprise. This is not readily available in Anaplan AppHub, but it is easy to create and maintain. This article will explain how to do it. Why we…
-
Formula to sum with condition
Hi, I need to sum the elements of one column based on an element "text" of another column. This text element isn't in a list so I can't use the function "Select". What formula can I use ? Thanks ! Best regards
-
3.3.5.2 Inventory Ordering Module Formulas - Beginning Inventory issue
I am getting the formula right - IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory However, I am not getting the desired results. I am getting IF and THEN part correct but i am not getting ELSE part correctly i.e., ELSE…
-
Performance of Comparision of Boolean using = sign over using NOT function
Whether using IF Approved? = TRUE THEN 1 ELSE 0 is good or optimizing the formula as IF Approved? THEN 1 ELSE 0 where "Approved?" is a BOOLEAN format line item. Same goes for, IF Approved? = FALSE THEN 1 ELSE 0 IF NOT Approved? THEN 1 ELSE 0 Please advise to optimize performance of the model.
-
Display Status (Pending, In-Progress, Complete) in a Dashboard
Hi, I want to display the status of each dashboard in a landing dashboard. And i want it to look like the photo below: Can someone suggest their ideas with this? Thank you and Regards
-
1.4.3.2 Import Data & Add Formula in Sprint 2
I am not able to find why time is coming ? Please help , I am completely stuck.
-
stuck on level 2 sprint 3.3 activity
hello i need help, please !!! I am stuck on level 2 sprint 3.3 activities I don't understand why i can't have the same results that course My results My formulas Level screen reference
-
Accuracy of calculations
Hello everyone 🙂 , we have two model builders who applied the same formula but with a different order, but since it's multiplication and division, the order doesn't matter. Unfortunately, I come across two different numbers. How accurate is Anaplan in calculations? Here an article i found Precision differences and large…
-
Create Shipping Export Module and Create a Saved View
Hello Community!! I am stuck at the above activity, can anybody please guide me what the mistake is?
-
Conditional Formatting on each Children
Hello everyone! I have a list with multiple children, and I want to apply conditional formatting (using boolean line item first) to each children at a time. How do I write a formula to select each children at the time instead of the parent? Basically I want to highlight every negative value for each sub list, but at the…
-
Create Shipping Export Module and Create a Saved View
Hi, I need help regarding this activity. 1) When I pivoted the view during Module creation - INV05 , I have an error regarding the G3 'location - saying " No Items" 2) The formula for Code is 'SYS06 Location Details'. Code' , but my SYS06 module seems to be unuploded Can anybody verify and let me know the exact mistakes.…