About KirillKuznetsov

KirillKuznetsov

Wonderful article, thanks for sharing @mitchellaist

KirillKuznetsov

@Jsdeloria21 The time system module can be created only on the backend. Filter can be applied in NUX, but you would most probably require driver for this filter and it can be created on the backend as well.

KirillKuznetsov

@Jsdeloria21 Not sure I understand 100%. But you can set filter on the periods you want to show when setting up the source table of the chart. Another option is to collect data always from referenced time period using lookup. I your case it will be previous to anything selected on the left chart. You can achive this having a system module dimensioned by time and a line item with previous year element in it. Years 2020 2021 2022 Year ITEM ITEM(Time) 2020 2021 2022 Previous year PREVIOUS(ITEM) 2019 2020 2021

KirillKuznetsov

@rob_marshall Thank you for the correction and addditional solutions. Good to know!

KirillKuznetsov

@saisri Short answer is TEXTLIST() https://help.anaplan.com/c1e24970-400f-43af-95e7-b34a43253cdb-TEXTLIST Or another version of it [TEXTLIST: ] I think the explanation of it much simplier here: https://help.anaplan.com/291bc437-9d30-48a4-a839-5246009fa0f2-x[TEXTLIST:y] It works as a SUM, but for text. So you would need additional dummy list with a single element in it to use as your concatenation argument. The following target module will take the value using [SELECT:Dummy list.Element]

KirillKuznetsov

@Ankushkedar Congratulations and welcome to the team! I would recommend you to share your progress with the world on LinkedIn and also take a look at Talent Directiory https://community.anaplan.com/t5/Available-Talent-Directory/ct-p/UserDirectory

KirillKuznetsov

@ssashish786 First of all i would recommend you to read this article: https://community.anaplan.com/t5/Model-Optimization-Checklist/tkb-p/model-optimization

KirillKuznetsov

@algrigore You can use mapping one list to another in order to lookup values from the source.

KirillKuznetsov

Hi @Apurv989 Could you please share dimensionalities of the two modules? You can find it in Appies to or Pivot of the modules. I think you should simply select the source and automatic aggregation will work or just a SUM function. But anyway let's look at dimensions first. Kirill

KirillKuznetsov

@muizzsk9890Happy to help @aniket9917How about you?

KirillKuznetsov

As model builder I have to change format settings for each number-formatted line item individually when it's created. Would be nice if somewhere in the system I could setup default number format to be applied automatically when new line item is created. In example below you can see that once created a line item has the following default settings: While my requirements say that number format has to be much different, which means many clicks to make each time: Obviously, I can use copy and paste from another LI which is ready. But the proposed feature could prevent me from forgetting to switch the format manually. And could help me focus more on model building rather than formating.

KirillKuznetsov

@whitbythanks for info @AnaplanIdeasPlease merge these two ideas Scroll on multiple grids at the time - Anaplan Community

KirillKuznetsov

@aniket9917 @muizzsk9890 Try to simplify name of the subset, for example rename it as "Active" (no brackets) and in formula write: ISNOTBLANK(FINDITEM(Active,Code))

KirillKuznetsov

@aniket9917 What error do you get?

KirillKuznetsov

@aniket9917 You have to create this subset with exact name in a Subset tab of Employees list. After this you will be able to mention it in the formula. Cheers, Kirill

KirillKuznetsov

@Lokeswar If you need to aggregate source data by time period (months) in target module you should use SUM function: https://help.anaplan.com/fa7ab44f-c31c-4928-88b3-9fe28ca8a774-SUM

KirillKuznetsov

@Lokeswar I suggest you to look at time functions in anapedia: https://help.anaplan.com/59773852-2955-4c72-a7e5-1f36207dd896-Time-and-date-functions For your use case to change date type to time period type you would need PERIOD() function. This requires to set target line item format to Time Period > Month. Cheers, Kirill

KirillKuznetsov

@vpkumarbi You can resize any text-formatted line item. I belielve you are having a list-formatted line item there. Please check

KirillKuznetsov

@Jsdeloria21pls refresh page

KirillKuznetsov

@Jsdeloria21 Apperently default view stays default in NUX and it seems like a bug (or maybe Anaplan forces us to avoid using default view this way). So to workaround you should use saved view or custom view, as I suggested.

KirillKuznetsov

@Brahmanambika Could you please provide screenshots? You can stretch the hight of any card.

KirillKuznetsov

@lloydramatshaba Could you please add some detials? What is the source numbers and waht is expected result? You can send as many screenshots you think is necessary for understanding. Thanks Kirill

KirillKuznetsov

@Jsdeloria21 It depends whether you use saved view or custom view as a source. If a saved view then you have to save it in the back-end (classic/dev interface) If a custom view (and Anaplan recommends to use custom views) then you have to pivot it in the edit mode of the grid Cheers Kirill

KirillKuznetsov

@hyudolee You can apply filter to the chart using separate module dimensioned by users and line item subset. Then publish this filter-module to the board so users can select elements they want to see.

KirillKuznetsov

@lilasququ You can apply filter on page selector and set rule that it's TRUE for first list item only. this will lock ability to switch between different projects though. Try to set two imports which will first set this filter and then remove it. Maybe it will trigger system to switch to the only one available option and then open up ability to choose other projects. Cheers, Kirill

KirillKuznetsov

@akprasa1 It cannot without a mid-step where you calculate which plant has been mentionned. For this I would recommend you to add to your transactional process a list named "Plants for transactions" which will be uploaded with unique codes of plants. Then this list can be used for analysis of the mentionings as I described earlier with FIRSTNONBLANK.

KirillKuznetsov

@akprasa1 Could you please describe the process a little bit more? What are these codes? Do they frequently change? May Loc1 have a unique code for each element in the list? Or it is some king of search mechanism?

KirillKuznetsov

@RavinderB You apperently refferring to wrong Product line item in lookup. This is why automatic sum is triggered. Please check if list in ‘SYS12 SKU Details’.Product is the same list as in dimension of ‘SYS14 Create Account>Product’.data?. You can try to add a Top level element in the SKU flat list to check what reult you are getting. Thanks Kirill

KirillKuznetsov

@akprasa1 Do i understand correctly that you want system to tick the boolean in cases when code in Plant LI is presented anywhere in Loc1 LI and does not matter which list element this Loc1 code belongs to? If so - then you should use firstnonblank for that. The mid-step module with plant codes list as a dimension with a boolean "Any Loc1" LI and a formula ISNOTBLANK(.Loc1[firstnonblank:.Loc1]). After this in Identified? LI should collect booleans using Any Loc1[LOOKUP:Plants]

KirillKuznetsov

@Arnab116 Main problem is that userlist doesn't have top level. You can try to use aggregation with a dummy list with a single element and a top level. This list can be used for SUM/TEXTLIST functions. The same list has to be used in calculation module to aggregate as a mid-step. After the aggregation you can pull this data to your target module as already you would have a top level in the calculation module. Kirill