About Amaya

Amaya · ‎09-22-2021

Hi @kavitha12345 , You have to use the Model Calendar, as everyone says. I think you can do this, but it will be complex and ugly. CAUTION! So do not take the below seriously. Module Grid Taichi

Amaya · ‎09-21-2021

Hi @Soumyajaiswal , How about making intermediate module for the Display names. Now you have 'module X' which has "SS:AS" as a dimension, and there is line item 'module X'.name. 1. Add boolean line item "SS:AS subset?" in the 'module X'. Its formula will be "TRUE" 2. Make 'module Y' which has "A" as a dimension, and two line items 'Name Import' and 'Display Name' 3. Import the display names to 'module Y'.'Name Import' instead of the list property. 4. The formula of 'module Y'.'Name Import' will be "IF 'module X'.'SS:AS subset?' THEN 'module X'.name ELSE 'Name Import'. 5. Set list item property to the 'module Y'.'display name' line item. module X module Y I hope this helps, Taichi

Amaya · ‎09-06-2021

Hi @neg177 , I would understand that you want to show 'weighted average' on the summary item. You already have had the weights, so you multiple the targets number by them. And sum the results and divide it by the sum of the weights. Let's use the ratio summary method as @KirillKuznetsov wrote. In this situation, the sum of weight equals 1 (A below), but it is needless even to calculate weights, and you can use the amounts directly instead of the weights (B). I hope this helps. Taichi

Amaya · ‎09-03-2021

こんにちは Dependent Dropdownについては、こちらの動画やAnapediaが参考になると思います。 https://community.anaplan.com/t5/On-Demand-Courses/Dependent-Dropdowns/ta-p/63723 https://help.anaplan.com/13135fc6-6d24-4f58-9dc5-8d1e021cff48-Create-a-dependent-dropdown-list-------- (Anapediaの日本語への切り替えがうまく動作しないですが。。) 2つのリストがあって、親・子関係でDependentにする場合には、親階層を選択肢に含むことはできないです。一方で、上記の動画で行われているように、リストA、リストBをPropertyとして持つ第3のリストCを利用してDependent Dropdownを作成する場合、例えばリストBが複合リスト（Composite List）で合った場合には、リストAのITEMとリストBの親ITEMを紐づけるというような対応は可能でした。ご参考になれば。。良ければ日本のコミュニティも活用ください。 https://community.anaplan.com/t5/Anaplan-Community-Japan/bd-p/jp Taichi

Amaya · ‎09-02-2021

Hi @AllMartin , How is it when uncheck 'Is summary' in the module blueprint? It would be this way now. ┌OPERATION INCOME ├Depreceation & Amortization EBITDA <- PARENT Regards, Taichi

Amaya · ‎08-19-2021

Hi @Jojo88 , It was a good challenge for me, and thank you for the question. I could make a solution for FIFO calculation, so please consider this. First of all, we should prepare an intermediate module for match productions and orders. It has a Time dimension and a list of purchase orders (Orders #). Intermediate Module If cumulate order quantity exceeds cumulate production quantity, we can say the production in the month is all sold. When the production items in the month are partly sold, we have to separate the cost of sold items from the remaining items. Then we could match the remaining items to the second order. I could hardly describe the idea well it is faster to look at screenshots or grid view excel. This solution works under the condition that production items in the month sold up to 2 orders. If the purchase order would be smaller and production separates into more than three orders, we have to improve this module. FIFO Module Outcome Order Module I would be happy this helps you, and any questions are welcomed Taichi

Amaya · ‎07-07-2021

Hi @DaanishSoomar , I think it would not be so hard to detect which level they are. (Please see the attached excel.) But implementing many-to-many relations with Anaplan will be challenging. Does it look like this? I'd like to keep an eye on the challenge. I look forward to seeing good practices emerge. Regards, Taichi

Amaya · ‎06-24-2021

FYI Difference 2 is less necessary because we can use NPV((1+r)^(1/12), Cash flow) in Excel as @tingtingxia did. In Excel, we can choose from two monthly discount rates. In the Anaplan, an exponential discount rate only, but it would be correcter Math.

Amaya · ‎06-24-2021

Hi @Roelofg I finally got to understand the Anaplan NPV function in the monthly calendar. Comparison with Excel NPV function: 1) Month 1 cashflow (E) discounted (A) not discounted 2) Discount Rate (E) ((1 + Annual Rate) / 12) ^ (Number of Months) (A) (1 + Annual Rate) ^ (Number of Month / 12) So in your situation, the NPV function of Excel and Anaplan differs. (E) 206,929 (A) 207,926 See attached Blueprint, too. Despite of the Anapedia NPV function page, you should set the NPV discount rate be the annual rate. I cannot fully understand this document. https://help.anaplan.com/c504a4f5-5513-42e3-91cf-b34d873d18f3-NPV This topic tought me how it works! Thank you. Regards, Taichi

Amaya · ‎06-23-2021

213,473... I will investigate..

Amaya · ‎06-23-2021

Hi @Roelofg , I think the NPV of this would be 206,929. Please check the excel attached, and could I see the whole formula of your NPV formula. I am on the way to studying finance, and it would be useful for me. I hope it helps.

Amaya · ‎06-02-2021

Hi @tonybol , Please take a look at this. This may help you. Regards, Taichi

Amaya · ‎04-30-2021

Hi @CommunityMember125605 It seems that 1 Jan is on 1st week in every year. And you can set a flag on the specific week in this way. You can use these flags as dummy variables in your statistic model. I hope it helps, Taichi >>>> I have changed the end of fiscal year setting. The week of 1 Jan moves, and It still works.

Amaya · ‎04-30-2021

I basically agree with @ChrisHeathcote's idea. Let's use VALUE[LOOKUP: Time Period] in the target module. In addition, I think the intermediate module is not needed. You have 'Deal Header Information input.Start Date'. It can automatically indicate which Time Period should be looked up. LOOKUP Period = START PERIOD + Month No Use the CUMULATE function below. Very useful. Month No = CUMULATE(Count, FALSE, 'Pseudo-Timeline') - 1 I hope it helps, Taichi

Amaya · ‎12-01-2020

Hi! It is simple. Write just "text". And it works this way. > IF Flag? THEN "text1" ELSE "text2" > When you combine some text and variables or text and another text, you should use "&". IF Flag? THEN "text1" & valiable1 ELSE "text2" & valiable2 Taichi

Amaya · ‎11-26-2020

HI, @neg177 It would look something like this. 1.　create a module to calculate the number of days to OFFSET number_to_offset : IF weekdays? THEN IF weekday <> 1 THEN -1 ELSE -3 ELSE 0 2．Rewrite in this way. (Cash Collected Forecast - Other Forecast) * IF 'S01 Time Filter'.Weekdays? THEN (OFFSET('Y03 Securitization'.Ending RTR Balance, number_to_offset, 0) / OFFSET('Y03 Securitization'.Ending RTR Balance, number_to_offset, 0) + OFFSET('Y04 Warehouse Tranche 1'.'Ending RTR Amount (Should Balance to BB Cert)', number_to_offset, 0) ELSE 0 I hope it helps. P.S. (* Y03 Securitization'.Ending RTR Balance / 'Y03 Securitization'.Ending RTR Balance ) will always 1 I'm sorry if I misunderstood...

Amaya · ‎06-23-2020

Hi, @RobinSilk Recently, I realized that it is sometimes easier to use the boolean input instead of choosing from dropdown list items. Here is an example. 1. You choose Parent Item (List: Lv1, Select_Parent.select) 2. 'Select_Example' module below is filtered by Select_Parent.select (GroupA). So you can choose from Child items of GroupA (Product A1, A2 or A3) 3. Boolean inputs on the not chosen item are hidden with DCA. In this example, 'Product A1' has been already chosen in 'A', and you cannot choose 'Product A1' in Item D. This may not be what you exactly want to build. But "Boolean Input with DCA" hopefully helps you. See attached blueprint Excel sheets in the detail. I hope it helps, Taichi

Amaya · ‎05-05-2020

Hi, @qsong1 I have no solution that helps your question perfectly. This is an idea which may suggest a little. You have two modules (input & calculation). And add a line item in each module which sums all line items in the module. Names are 'input' and 'calculation' below. They become the parent of all other line items. Then you set a line item subset (LIS_input&calc). Let all line items be into that subset. Make a new module using that subset and set a formula below. Parent(=module_name) = PARENT(ITEM(LIS_input&calc)) This screenshot shows how it works. Regards, Taichi

Amaya · ‎03-26-2020

Hi, @Star https://community.anaplan.com/t5/Best-Practices/Changing-the-Sign-for-Aggregation/ta-p/53812 This article may relate to your topic. This is a great trick. I hope this helps you. Taichi

Amaya · ‎03-13-2020

Hi, Jim @jimfeng5 I think I understood that logic! (I love this kind of a puzzle 😉 ) The Broadcast Month seems to be determined by the month of the end date of weeks. For example, the 35th week in 2020 is contained in August in the BM, because the week ends on 30th August. Anaplan calendar 4-4-5 sets that week September. (By the way, your image of the calendar has two 26th weeks ^^) So, you have to check whether the end of weeks and the end of 4-4-5 months are the same dates. See below and attached. And I made a month dimensioned module and try x[SUM: Broadcast Month], but I was said that was illegal. So, once you get Broadcast Month in this way, you have to make a "fake month" list to wrap up the result. Or option B is the way of "Weeks count" in the module. Sum up next week's value into this month when next week is BM adjust week. I hope I am correct and this helps you a bit. Here is the time setting. Regards, Taichi

Amaya · ‎03-10-2020

How about doing this? You select one list item and you can filter items that match their property and the chosen item. Please refresh the dashboard. Notice, because this (choose ->) affects other user's view, it would be better to include Users as a dimension in step1 and step 2 module. I hope this could be a hint. Regards, Taichi

Amaya · ‎02-25-2020

Hi, @ChrisHeathcote Is this truly a topic with Line Item Formatting issue? I understand your situation this way. You have two modules, and their line items are all the same, includes formatting. One is for actual data, and one is for inputs of the forecast. You and your customer want to synchronize these two modules when the model grows and needs more Line Items. It concerns maintainability = sustainability. If so, please let me know why you need two modules instead of one. Is there some technical difficulty in combining two modules? For example, the formula scope functionality doesn't meet your requirements? I would like to specify your wants more and think about the best way to solve this. Best regards, Taichi

Amaya · ‎02-25-2020

Hi, @dock Is this similar to yours? Getting a comments (editable text line item) at summarized level https://community.anaplan.com/t5/Anaplan-Platform/Getting-a-comments-editable-text-line-item-at-summarized-level/m-p/61226 Sorry, if I misunderstood your intention. Regards, Taichi

Amaya · ‎02-22-2020

Your Japanese sounds natural. Google translation is awesome! We would be happy if you share your experience with us. Regards, Taichi

Amaya · ‎02-22-2020

Hi, @JaredDolich Thank you for reading my post despite the language barrier. If this helps some, I gladly would prepare writing in English. How do you think about it? I believe we can be more user-friendly in Anaplan and give others fun like playing games. 読んでくれて、ありがとうございます！ Thank you again, Taichi

Amaya · ‎02-22-2020

こんばんは。軽めのネタをシェアさせていただきます！最近、自分の仕事ではない子会社や他部署への展開が多くなっていて、設定やメンテナンスも彼ら（Adminではないユーザー）にある程度任せたいという案件が徐々に増えてきています。そうすると、ユーザビリティというものを少しは意識せざるを得なくなってきています。そんな中で一つサンプルを作ったので、シェアさせてください。ダイナミックセルアクセス（DCA）を使って、リストアイテムの選択ではなくチェックボックスで一つを選んでもらうというものです。ポイントはDCAで２つの機能を実現しているというところかと。 ※ Chooseを、Read Access DriverとWrite Access Driverにしています。 ※ Selected_ItemとColorはRead Accessのみを設定 1）１つを選択すると他のチェックボックスを触れなくなるという機能 2）Colorという条件付き書式に利用しているITEMも非表示にすることで　それを利用する条件書式も非表示になる＝視認性が上がる BluePrintのエクセルも添付しておきます！よければやってみてください。黄色／水色、結構好きで気に入ってます。これを応用すると、必ず2つ選択してもらう、というアンケートっぽい設定もできますね。 Display? = Choose OR Color[SELECT: Choice.ALL] < 2 こういうエンドユーザーにとってフレンドリーな事例について他にもひきだしを増やして行きたいのですが、みなさん何かお勧めのもの、ありませんでしょうか？知りたいです。お願いします！では！ Amaya

Amaya · ‎02-22-2020

待ってます！ We all welcome you!

Amaya · ‎02-21-2020

Hi, @taku.s My solution is almost the same as @Misbah 's. I think I could adjust it to your circumstances a little. Don't forget to set the summary to Time: Last non-blank. (By the way, your screen name sounds like Japanese. If you are a Japanese person, please drop at Japan Community, too. There are very few people and we want more knowledge to be shared in the Japanese language.) https://community.anaplan.com/t5/Anaplan-Community-Japan/bd-p/jp Best regards, Taichi

Amaya · ‎02-21-2020

I'm glad. FYI This really helps. I have read 4-5 times. This solution is here, too. Line Item Subsets Demystified https://community.anaplan.com/t5/Best-Practices/Line-Item-Subsets-Demystified/ta-p/54309

Amaya · ‎02-21-2020

Hi, Alright! Uncheck Is Summary. You can write a text on the summary row. Regards, Taichi