-
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のような式を作りたいのですが、どうすればいいでしょうか
-
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
-
Level 3. Build Sales Role and Sales Reps
Hello, Sales Role and Sales Reps# are flat list in Sales Planning Model. In the Sprint2, the ask is to create import to build them up. I am using SYS09 Employee Details module in Data-Hub, but it is not working. Any Advice? Thanks
-
TEXTLIST- multiple dimensions
Hi Could any Anaplan pros please assist with a TEXTLIST aggregation? I am not sure how I would do this over multiple dimensions. It is basically concatenating all the applicable pages numbers into one text based line item for each employee / report version / user. I have attached the blueprint. The line item I am trying to…
-
Can someone plz post a relevant use case and user story related to investment banking
I have completed my level1 and 2 certification, I am looking to go little deeper into investment banking for an asset management company use cases, modules and lists. appreciate your feed backs and posts bala
-
Level3. Create Action with filter
Hello, As explained in the Level3 study material, I added country and segment as properties to "G4T Territory>Account#" but I still can't see them in filter section when I create an Action. Please advice. Thanks
-
Mapping time when importing csv file
Hello I have an issue when mapping the time when importing a csv file could you pleae help?
-
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,…
-
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:
-
Level 1 10.2.6
Hi, Even if I enter the formula as instructed, it is not reflected. Any help is appreciated. Thanks.
-
Level3. Territory>Account module
Hello, I created a module in Data-Hub to transfer the territory>account to Sales Planning model in a numbered format to use as a dimension. However, I am pretty sure that something is incorrect with my module cause all the accounts listed in each territory repeatedly. Any idea what is wrong here? Thanks,
-
Anaplan does not sum the filtered list items but it sums all list items
Is there a way to sum only the list items that I filtered? Now All directions is always the sum of all the list items and not only the list items that I filtered
-
Level 1 9.2.5 Unit Price %
Hi, When I try to copy and paste this formula I get the below error and cannot seem to work this one out. The formula for 'REV05 Price Growth Rates Staging'.Unit Price % is invalid: Unit Price % = 'REV04 Price Growth Rates'.Unit Price%[LOOKUP:'SYS04 Location Details'.Country, LOOKUP:'SYS06 Product Details'.Product Family]…
-
Level 3. QUO01 Territory Account
Hello, In the QUO01 module, I am using formula below to get target number, but I get 0.00; I even tries to add LOOKUP account names but still no luck. Also, for Assing>1 I am writing this formula, but it errors out: IF 'SYS07 Territory Account Details'.Count[sum:'SYS07 Territory Account Details'.Account> 1 THEN TRUE ELSE…
-
How can I permanently HOLD the TOTAL figure and let the Breakback happen?
Hi Community, Need your help if you have a smart solution to HOLD / LOCK the Top/Total of certain dimensions of a line item which is Breakback enabled! Example screens is given below: So, all I want is to HOLD the yellow circle i.e. 1849 amount and let the below gets change which is 4 levels hierarchy.. We know the HOLD…