关于ssicefox

ssicefox · 09-23-2021

Hi @Srisesh9 , Thank you very much. Best regards. Wei

ssicefox · 09-22-2021

嗨，恭喜！我今天完成了3级型号建设。感谢您的帮助，特别感谢Anaplan社区给我提示和支持。此致。魏

ssicefox · 09-20-2021

Hi, @ JaredDolich I created the dashboard Account Assignment Exceptions, but the button "Finalize Assignments" did not work. I created the Action " Finalize Assignments" with "G4T Territory>Account#.Display Name". How did you realize it? Can you please suggest if I am missing any other instructions? I went through all the use cases multiple times but could not find any further instructions. Any hint/clue is much Appreciated. Thanks in advance! I am looking forward to hearing from you soon. Best regards. Wei

ssicefox · ‎09-17-2021

Hi @Misbah Thank you for your reply. I deleted my previous queries having the blueprint or formula. Here is my result of QUO07,but it is not right for Target and No.of Account. I filled G3S Sales Reps# and Sales Reps Flat# . If Target of QUO07 doesn't apply to Sales Reps Flat#, I will receive an error message: I tried using LOOKUP function on Line Item "Sales Role" of QUO07 to obtain the Target of every Sales Rep, but I didn't obtain what I want. I am looking forward to hearing from you soon. Best regards. Wei

ssicefox · ‎09-17-2021

Hi, @ Misbah For calculating the Target of Sales Rep, I created a Line Item Sales Rep in TAR02 Account Review and created a formula of Target applying to Sales Reps Flat# in QUO07 to obtain the Target of every Sales Rep, but I received a message, but the result is not good. The Target showed Total of all Sales Reps and didn't show Total of every Sales Reps. Any hint/clue is much Appreciated. Thanks in advance! I am looking forward to hearing from you soon. Best regards. Wei

ssicefox · ‎09-14-2021

嗨@Misbah, @Gauravkumar90 @JaredDolich如何you? I am trying to upload the CYW Scenario Territory to Accounts.CSV into the Territory>Account# List, but I did find a solution to concatenate Territory code and Account code for filling the Code column. Any hint/clue is much Appreciated. Thanks in advance! I am looking forward to hearing from you soon. Best regards. Wei

ssicefox · 09-13-2021

Hi, @richbhar, How are you? I can't upload the file "CYW Scenario Territory to Accounts" in the G4T Territory>Account# List to fill " Display Name". How did you pivot G4T Territory>Account# List? Any hint/clue is much Appreciated. Thanks in advance! I am looking forward to hearing from you soon. Best regards. Wei

ssicefox · 09-13-2021

Hi, @BahalR Please tell me how to fill the Line Item "Display Name" in the G4T Territory>Account#? Should I create a module SYS15 Territory>Account to fill the G4T Territory>Account#? Any hint/clue is much Appreciated. Thanks in advance! I am looking forward to hearing from you soon. Best regards. Wei

ssicefox · 09-13-2021

@SuhasDesai IF THEN ELSE

ssicefox · 09-13-2021

@SuhasDesai You lost " ELSE".

ssicefox · 09-13-2021

6attempts

ssicefox · ‎09-11-2021

嗨，Welcom加入Anaplan家族。您应该遵循每一章的说明。此致。魏

ssicefox · 09-09-2021

Hi @rob_marshall, Thank you for your help. I tried changing the summary of that line item to be Formula instead of Summary, but that is not allowed by Anaplan.

ssicefox · 09-09-2021

Hi @JaredDolich @Misbah , How are you? I completed the User Story 1.11. But I have a question. When I select All Account, the % of Account Sales Target aggregate automatically. Any help would be appreciated. I am looking forward to hearing from you soon. Best regards. Wei

ssicefox · 09-05-2021

嗨@chrisheathcote，你好吗？我有一个使用TAR02和TAR03模块来计算重新分布因子的问题。我想知道如何计算除被覆盖或持有的帐户以外的所有帐户的总和。我也有关于持有或修订的问题。此项目仅包含保留还是覆盖值？TAR02帐户评论模块中的“更改”项目是什么。TAR03模块中的“检查”是什么？任何提示/线索都非常感谢。提前致谢！我期待很快收到您的来信。 Best regards. Wei

ssicefox · 09-05-2021

嗨@misbah，你好吗？我有一个关于持有或修订的问题。此项目仅包含保留还是覆盖值？什么是“更改”的项目？请给我一些提示。谢谢。魏

ssicefox · 09-05-2021

嗨 @ misbah，@jareddolich你好吗？我正在填写TAR03国家帐户计算模块。我想知道目标是否是初始帐户销售目标的总和。什么是支票？任何提示/线索都非常感谢。我期待很快收到您的来信。此致。魏

ssicefox · 08-25-2021

hii，@jareddolich，我得到了用户故事1.6的结果：数据来自“ tar02帐户评论”。使用国家和细分市场的总和。公式如下：“ TAR02帐户评论”。启动帐户销售目标[sum：'sys02帐户详细信息'。国家，sum：'sys02帐户详细信息'。细分]您能告诉我我的结果是否正确吗？请。此致。魏

ssicefox · 08-25-2021

hii，@misbah，@jareddolich，我得到了用户故事1.6的结果：数据来自“ TAR02帐户评论”。使用国家和细分市场的总和。你能告诉我我的结果是否正确吗？请。此致。魏

ssicefox · 08-23-2021

Hi @JaredDolich Thank you for your reply. Please find my formulas following: 1. PY Country and Product Family Sales: Baseline Financial Forecast.Baseline Financial Forecast[LOOKUP: 'SYS03 Account>Product Details'.'G2 Country', LOOKUP: 'SYS03 Account>Product Details'.'P1 Product Family'] I don't use the formula following for PY Country and Product Family Sales 'DAT02 PY Revenue to CY'.Revenue[SUM: 'SYS03 Account>Product Details'.'P1 Product Family', SUM: 'SYS03 Account>Product Details'.'G2 Country', LOOKUP: Country, LOOKUP: Product Family] 2. Initial Country Sales Target: 'TAR01 Sales Targets'.Initial Country Sales Target[LOOKUP: 'SYS03 Account>Product Details'.'G2 Country', LOOKUP: 'SYS03 Account>Product Details'.'P1 Product Family'] Here is my result. If the User Story 1.4 is the continuity of the User Story 1.2, the Initial Account Sales Target / PY Account Revenue should be 101% for US, or 105% for Italy. I created the TAR01 Sales Target following that corresponding the example below. Please tell me if my result is right, specially PY Country and Product Family Sales and Initial Country Sales Target. I am looking forward to hearing from you soon. Best reagrds. Wei

ssicefox · 08-23-2021

@JaredDolich感谢您的答复和提示。我将与您分享我的公式。此致。魏

ssicefox · 08-23-2021

嗨@JaredDolich，我得到了TAR01的结果：在此结果中，对我们来说，初始帐户销售目标 / PY帐户收入= 101％，这对国家 /地区的百分比增加了（用户故事1.2）。@konstantingrishachev的结果如下：在他的结果中，对我们而言，初始帐户销售目标 / PY帐户收入= 114％，这对国家 /地区的百分比不符（用户故事1.2）。您能告诉我我的结果是否正确吗？此致。魏

ssicefox · 08-23-2021

Hi @titiboys The percentage increase of US is 1.0%.

ssicefox · 08-23-2021

@Misbah Thanks for your reply. I resolved the problem yesterday. Best regards. Wei

ssicefox · ‎08-22-2021

Hi @abhi1017, How are you? I just created the TAR01 module, but the number of Initial Country Sales Target is not correct. Here is correct number: I think my formula of Initial Country Sales Target is not correct. Could you give me any hints? Please. I can't find where the problem is. Can you help with correct formula for that item? Best regards. Wei

ssicefox · 08-21-2021

@Misbah Thank you for your help. I got it. Best regards. Wei

ssicefox · 08-21-2021

Hi, @swapnil_J, Thank you again for your hint. I populated "Product Flat" Line item. But P2 Product doesn't have any data as well. I tried the method of @Suneela, but I can't change the format of P2 Product and Product Flat, so I am not successful to use her method. Best regards. Wei

ssicefox · 08-21-2021

嗨，@misbah再次感谢您的提示。我填充了“产品平面”订单项。但是P2产品也没有任何数据。此致。魏

ssicefox · 08-21-2021

@Misbah The P2 Product data isn't showed in SYS03. I tried to add a formula for P2 Product, but I am not successful. Best regards. Wei

ssicefox · 08-21-2021

Hi, @Misbah Thank you for your hint. I tried 3 lookups (A1 Account, P2 Product and PY Qtr) together, but I received nothing. I think I should import data of P2 Product into the SYS03 before looking up. Best regards.