About Amaya

Amaya

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

Thank you, @Jared Dolich 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

Hi, @Jared Dolich 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

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

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

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

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

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

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

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

Amaya

Hi, @MadhabikaM It may be helpful to use cumulate function along with line items. Please see this anapedia in detail. https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/CUMULATE.html And here is an example of Year adding. I hope this could help you. ▼See CUMULATE('Number_1', FALSE, CHRT) If you don't set the current period, you may have to choose 'initial_year' manually. ▼Here is the result. Regards, Taichi

Amaya · ‎12-02-2019

Is this what you meant for? If you have the model calendar, you can use 'Previous' formula (as Mr. @nathan_rudman said) and avoid circular reference. In original topic, it seems not to use the model calendar, and it is difficult to avoid circular reference, probably. (Sorry, if I've misunderstood your question.)

Amaya · ‎11-26-2019

というタイトルの記事が出ておりました。ちゃんと読んだら、とてもよかったです。いままでVersion Formulaというものをちっとも理解していませんでした。わかってみるとすごく便利。同じ式をたくさんコピー＆ペーストしていたのは無駄な作業でした。。Formula Scope だけではできなかったこともできますね。もっと早く知っていれば良かった。 Best Practice - Line Item Subsets Demystified https://community.anaplan.com/t5/Best-Practices/Line-Item-Subsets-Demystified/ta-p/54309 目からウロコが落ちたので、Version Formulaというのはこういうもの、という図を書いておいておきます。私以外にも、ウロコが落ちる人がいるのではないかと。（私だけ？？）ちなみにAnapediaでは、ここに書いてあります。何度か見ていた気もするのですが、ちっとも分かってなかった。 https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Add_Version_Formula.htm?_ga=2.242975362.1201305968.1574735694-1543111777.1571100531 今回、Line Item Subset の流れで説明してもらったほうがピンと来ました。記事中の他のLine Item Subset使い方も、一度は使ったことはある感じでしたが、やっぱり便利ですねー。ちょうど今、新しい会社の予算モデルを作っているので、タイムリーに勉強になりました。メンテナンスのしやすさ＋見やすさを考えると過去分も適宜このかたちに直したいです。では、また～。

Amaya · ‎11-13-2019

コミュニティで流れてきて、面白かったのでシェアさせてください。 Best Practice -> Changing the Sign for Aggregation https://community.anaplan.com/t5/Best-Practices/Changing-the-Sign-for-Aggregation/ta-p/53812 かいつまんで言うと… 　　　　 Value ┌売上　1,000 ├原価　800 売上総利益　200 というように階層でPLを見せるには、という記事。ポイントは１．科目貸借（貸方-1・借方+1）のratioというLINE ITEMを用意する２．入力値（value）にratioを掛けたtempというLINE ITEMを作る３．tempは売上1,000、原価-800なので、売上総利益200になる４．PLとして表示したいvalueの、Summaryを「ratio」、temp / ratio にする。詳しくは元記事をご参照ください。科目貸借フラグによって借方・貸方の符号を変えて、足し算で利益が出るようにするのは会計システムとしては通常なのですが、貸借フラグを掛け算ではなくratioという割り算で実現するところが、「その発想はなかった！」という記事でした。すごくとんちが効いている。作っているモデルに組み込むか、というと微妙ですが、PLのインポート結果が正しいかどうかのチェックなどには簡易で良さそうな感じ。（こんな感じで、また気が向いたら投稿させて下さい。　Amaya）

About Amaya

Re: Last Occurence

Re: Cumulate Issue

Re: Cumulate Issue

Re: Using Model Role to filter

Re: Using Model Role to filter

Re: How to count booleans?

Re: How to get the last row number

Re: Alternative to LOOKUP with non-composite hiera...

Re: Formula issue - Add value from previous month...

Re: How to make two versions formula driven and on...

Re: Pouplating year value without Time dimension

Re: Circular reference with previous value

Line Item Subsets の神秘を解き明かす

LIST ITEMの階層で損益計算書を作る方法

Re: Cumulate Issue

Re: Formula issue - Add value from previous month...

Re: Pouplating year value without Time dimension

Re: Formula issue - Add value from previous month...

Re: Pouplating year value without Time dimension

Re: How to count booleans?

Re: Alternative to LOOKUP with non-composite hiera...

LIST ITEMの階層で損益計算書を作る方法

Re: How to get the last row number

Re: Using Model Role to filter

Re: Using Model Role to filter

Re: How to count booleans?

Re: Alternative to LOOKUP with non-composite hiera...

Re: How to get the last row number

Re: Using Model Role to filter

Re: Using Model Role to filter

Re: How to count booleans?

Re: Alternative to LOOKUP with non-composite hiera...

Community Vlog #3: Master Anaplanner Program—Beaur...

7 Inspiring Books: Anaplan Community Reading List

Re: Community: Love Is in the Air!

Re: Community: Love Is in the Air!

Community: Love Is in the Air!