-
Custom date log / History Log
Anaplanners, Currently, our user group updates a checkpoint where they record completed tasks, such as onboarding tasks, by entering the completion date in a date-formatted line item. We have developed a custom-built grid that displays changes in a funnel chart format, showing the latest update for each project, with the…
-
Network traversal algorithm using Anaplan
Has anyone implemented a network traversal algorithm in Anaplan? To explain the problem, refer to screenshot below. What I want is to generate a path that goes through all the nodes, e.g. Node 1 to Node 3 then to Node 4 then to Node 2 that returns the path with the lowest weighting. So Node 1 to Node 3 is 7 (as per…
-
Leading zeroes in anaplan
I want to fix the length by appending zeroes :- Consider below example where i am having 3 Prod ID :- 1234 1234567 123 Below is the result i am expecting:- 0000001234 0001234567 0000000123 Generally we call this left/right padding or leading zeroes.
-
コード、テキストを並べて表示する
下記のようなグリッドを作りたいです。コード対応するテキストを表示したいのです。 どのようなリスト構成？にすればいいでしょうか。いま、”111_choco"みたいなものを作っていて、美しくないのです。
-
Efficiency of the lookup formula
I have some question about how efficient the lookup formula is I have a situation where we when we have new items have the ability to give that item a mapping to another item to pull some initial data for since we don't have anything for it yet. we used a lookup instead of just repopulating the initial data so the users…
-
DAT01 Beginning Inventory data issue
Hi, I am currently working on 3.3.5.2 Inventory Ordering Module Formulas and just realized that my 'DAT01 Beginning Inventory' is showing funny numbers. I can see the number 845,329 is the total value of beginning inventory. I tried to find out the cause in the community but I could not find the answer. Can anyone help to…
-
Is there a way to get current user value in a line item for a module that does not have user dimen
Is there a way to get current user value in a line item for a module that does not have user dimension
-
How to get MAX value from line item to another line item in the same module?
Hello, I have a module (image below), how can I create a line item where all items will be max value from 'New Store Num' where 'To many Stores?' is True . For Example in image below it will be 8.
-
How to Resolve “Automatic Sum of Hierarchy Not Possible” Error Without a Top-Level Item?
Hi Anaplan Community, I’m encountering an error in my model: “Automatic sum over Over/Under hierarchy is not possible because the list does not have a built-in top level.” I understand that one solution is to set up a top-level item in the list. However, I prefer not to use a top-level item. I’ve read that using a LOOKUP…
-
Level 1 Lesson 7.2.3 - Why is Department grayed out?
There is no way for me to map Dept Code to Department as Department in the Target Items is grayed out. Anybody knows why this is the case?
-
Getting the total from another Module
Hi everyone i have a module [Employee Details] where i can filter the team center. for the below sample, i chose the Financial System which has 2 employees. whenever i choose Team Center, the amount will be selected in [Sum Selected] column. in my Testing 1 module, the only Total would reflect must be Financial System. but…
-
get inventory per country per sku
I have an Invenotry ordering module where i have beginnening inventory, i want to get the inventory in a new moudule by country and by country and sku both i have a sku details module which has country made in as lst item and sku as a dimension i tried using this formula but got no data 'INV01 Inventory Ordering'.Beginning…
-
Instructions on how to develop a Model Schema
Hi there, Can someone please provide step by step instructions on how to develop a Model Schema per project (DISCO base). Thanks in advance, Siva.
-
How to tackle duplication import into numbered list with list formatted properties ?
When importing into the list having properties as list formatted it create new list item with every import even if unique identifier already exists While importing transactional data into a List (Numbered List) which has properties Country formatted as Country, Year formatted as Year and Amount formatted as Number. In…
-
Displaying Line Item Based on Date Range
i have a module where i have line items such as client number, agent name, start date, end date and months between end and start date now i have another module where i am using client number as an dimension also time(months) and agent as line item now i want to display the agent name from the first module to this module…
-
Issue with Ascii characters in Anaplan
I’ve encountered an issue while importing data into Anaplan where certain special characters, specifically ASCII characters like ü, ä did not show properly, it showed as question mark Instead of importing these characters correctly, the data gets corrupted or replaced with incorrect symbols. As shown below, Although it was…
-
Find common text between another modules without List
Hi, I want to find common text between another modules. I have two modules A&B. Each module has order Number and Product(Text format) I want to find Product(ModuleB) in ModuleA. It's Common Text. In this case, we can find product by finditem formula, by making product List. But I don't want to use product List, because it…
-
Cumulate calculation but skip 1st item
Do you have any ideas to calculate this; what I need? If I make a line item called "for lookup" and use LOOKUP formula, I can do this. However I need to fill in "for lookup" manually. I simplify the case here and "Figure" should be calculated using "What I need", so I cannot use "Figure" since it becomes circulation…
-
1.4.5.2 Import from Saved View
Can anyone help me with the mapping of this?
-
カテゴリー別合計が上手く出ない
作成したいのは赤枠モジュールです。 指定期間の数量Aの合計をカテゴリー別で出したいのですが上手く出ません。 お力添えいただければと思います。