About Amaya

Amaya

Hi @PWCAnaplan You could use a Line item subset to choose A, B, or C. So it would work by writing the same sum function three times But I doubt that it is the best practice. FYI, Taichi

Amaya

Hi, @tompatrick.ting You might want to read this best practice. Line item subsets demystified - Anaplan Community I owe the article much. Regards, Taichi

Amaya · ‎06-09-2022

素晴らしいアップデート！お知らせありがとうございます。特にスクロールの同期、とても良いです！

Amaya · ‎06-07-2022

Sorry for my lack of Explanation. The "A" above is Parent of A1,A2,A3,A4. The Summary of GP Margin is 'Formula', so the GP Margin is the correct figure of 0.4.

Amaya · ‎06-06-2022

Hi @elaine.novel , This approach may not be elegant. We can use the if statement and change the behavior of each LIS. Here is the System module for the calculation above. For more detail, see the blueprint attached. I hope it helps, Taichi

Amaya · ‎04-14-2022

Is the formula in this screenshot different from the original one?

Amaya · ‎04-06-2022

Hi @weilun.wong This is similar Q&A https://community.anaplan.com/t5/Anaplan-Platform/Last-Occurence/m-p/60979#M11060 And in your case, since the output has Months as a dimension, the intermediate module must also have Months. To display the last day of the month, you would get the rank of the dates with the RANK function and then calculate the biggest RANK number of the month in the intermediate module for each product. You return the result to the flat file module then you know which data to aggregate as you have painted it yellow. The results can then be displayed by linking the output module with a MAX or SUM function. Hope this helps, Taichi

Amaya · ‎12-20-2021

Hi @peggytham , How about using a Scatter plot, instead? Convert 'Grade list item' and 'Performance Rating' to number format and plot them like below. The scatter plot allows conditional formatting! https://help.anaplan.com/5f30056b-80b8-42c6-839d-a8fc0521f290-Scatter-plot-and-Bubble-chart Thus, you could draw a graph below. I hope this helps, Taichi

Amaya · ‎11-24-2021

Hi @Sachinsourav02 , If you have not read this good article yet, you might want to read this. I will be glad to explain when further information is needed. https://community.anaplan.com/t5/Best-Practices/Increase-End-User-Adoption-With-Smart-Filters/ta-p/42821 Regards, Taichi

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 @ChrisAHeathcote'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