About Amaya

Amaya

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

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, @takushimozuru 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

Amaya · ‎02-20-2020

Exactly, you are right. Handling many rows of data, you should recommend your customer to design the list in the proper way with unique code. Now unexpectedly your customer may like copy from the excel 🙂 It may vary on the use case. Try many. Good luck, Taichi

Amaya · ‎02-19-2020

Hi, @ArunManickam Here is a quite simple solution. ・Create a numbered list. Numbers of items can be as many as you need. （It won't exceed 1,048,576 because of the excel limitation.）・Build a model with the list. And prepare line items, same as excel. It would be better to make some list items to catch specific data. ・So let's copy and paste data from the excel. You might think that I am joking, but why must we always use the import action? I believe copy and paste is the great invention of data integration. Perhaps, most Anaplanners would not recommend this kind of implementation. Yes, this is a mere imitation of Excel. But many people love excel and its functionality like your customer. And I assure that your customer can enjoy benefits from this Excel-ish implementation than using Excel. As below. 1) Easy check of the irregular inputs by using list item format (End users sometimes destroy Excel formula or ignore the dropdown list) 2) Of course, the history functionality of Anaplan 3) Single source of truth Besides, proper usage of DCA implements the additional functionality as follows. 1) Once data input through copy and paste, no one can change the data. 2) Some users can read limited items only. It can be a system, especially when the data is critical for the customer. Think about this implementation. Regards, Taichi

Amaya · ‎02-19-2020

Hi, @PujithaB I suppose that you mean like this, don't you? I set three modules. 1. Choose from List -- dimension: numbered list (#1-20), Line item 'Choice' formatted as the List Item Choice(A-D) 2. Process -- dimension: numbered list(#1-20) & Choice(A-D) Line Item 'Which' is described below numbered list has build-in top level and its summary method set as 'Lastnonblank' 3. What is the last row -- dimension: Choice(A-D) Line Item 'the last row' = process.which I hope this works in your model. Regards, Taichi

Amaya · ‎02-13-2020

Thank you, @JaredDolich I apologize to make a topic confused. Please take a look at the screenshot on top of this topic, the Cumulate on the 12th month is 90. And yours is 145. That's the difference between cumulate and previous, I think. But this may go off a topic. Actually, I am not so sure what this discussion is about. It would be better for me to wait for some further information.

Amaya · ‎02-13-2020

Hi, @JaredDolich I don't think this is so automatic. We have to make another line item to use the PREVIOUS() function instead of CUMULATE(). CUMULATE(Value) + plus Value <> PREVIOUS(Cumulate) + Value + plus Value. In this case, PREVIOUS() running sums plus Value together. That is not the desired outcome. INCORRECT BELOW. I have to reconsider.. Now I don't clearly understand what "Excel Driver" means. If I reproduce this behavior of the function with Anaplan calculation, it may be like this. new LINE ITEM = OFFSET(Cumulate Formula, -2, 0) + OFFSET(Value, -1, Value) Cumulate Formula = new LINE ITEM + plus Value I cannot understand why so odd way this function runs. It may be just my misunderstanding about how it works. Regards, Taichi

Amaya · ‎02-09-2020

If we want to do this, we may have to prepare a dummy role instead of "No Access". And we can't set the dummy role as a default, can we?

Amaya · ‎02-09-2020

How about thinking about it from the opposite. Create a module to maintain user properties and roles, and import data from the module to the user list. I have not done this experiment, though...

Amaya · ‎02-09-2020

Hi! The simplest way will be below. New Item = if boolean then 1 else 0 And sum this item. I am afraid that you feel some dissatisfaction with doubling cell counts to get one mere aggregation number. But if I were you, I would do this. A tricky way is sometimes not well understood by others. I hope this helps, Taichi

Amaya · ‎02-07-2020

By the way, I think your question is normal when you use excel. When you're in Anaplan, it could be slightly different. Excel has one row with two statuses, having data or a blank. Anaplan row is (should be) determined with two statuses that exist or not. You ought to keep every row has some meaning to exist, or don't generate a vacant row. If you get some new data, add rows (items) as many as you need. (...Sorry that I am far from your question. )

Amaya · ‎02-07-2020

I suppose I could see what bothers you. Perhaps, it occurs like below with one list item that has a hierarchy in it. Once I tried to solve this with some tricks, but after all, I got to know regularized hierarchy is the best. Sorry, I don't have a good answer. I am watching how this discussion goes, too. Regards, Taichi.

Amaya · ‎02-06-2020

Sorry if I don't understand what you want to do. How about this? It looks like yours. IF Identifier THEN CUMULATE('Value 1') - 'Value 1' ELSE 0

Amaya · ‎02-05-2020

Version formulae are awesome. This best practice is really helpful. Thank you, David-san. Best Practice - Line Item Subsets Demystified https://community.anaplan.com/t5/Best-Practices/Line-Item-Subsets-Demystified/ta-p/54309