About ankit_cheeni

  now i cannot enter the value as mentioned in the image  ... View more

Make sure that you check your values in TAR04 Account Segments Total By Country Module after you have imported the file provided. This mismatch is because that. Read carefully and proceed. ... View more

You are okay the world is all wrong. Lol ... View more

Hi @khoonks    This solution will only work if your line items are number formatted. Here is a stepwise idea of what to do: Create a line item subset and select your module   Open the Line item subset and select the line items you want to be a part of this:   Create a new 'Filter' module dimensioned by this line item. Add a Boolean formatted line item 'Filter for export'. This is where your users will select the line item they want to export   Add a filter in your export module using this line item you created:   Export this view!     Hope this helps ... View more

@ankit_cheeni I could see that working, yes. I'm confused on how to add 1 to a previous code if the two attributes are selected again at a later time.   For example: If OpEx(OE) & Hardware(HW) are selected as attributes, the code = OEHW1. If in the future they add another expense of OpEx & Hardware, how can I make it that the code = OEHW2? Or to uniquely identify each expense? ... View more

Hi @Vibhas    Compare the time you see in your data (Jan 20) vs what you are mapping it against (2019-01). You need to go to time tab in your mappings and update it (to something like MMM YY). This would solve problem 1.   Second is in your mappings, map column headers to line items and then go to line item tab and make sure Demand is mapped to Volume.    Should work then. Happy to get on a call if that is quicker. ... View more

Hi @johannadreano    That is a good questions and I remember it confused me for a long time on where to make the changes. I will try to answer your question in points We call 'coloring of cells' conditional formatting in Anaplan  You need a number formatted line item to set CF. You need a minimum of two numbers and max 3 and assign colors to the numbers. Basis your selection, you get the cells colored (either step wise or within a spectrum).  You can do it within a module in a saved view (usually not recommended) or you can do it directly on the NUX (this has more color/type options)   In your case, you'd need to create a number formatted line item in your module, the formula would be something like:  IF   'the node is already created and unchanged' THEN -1 ELSE IF 'the node is already created but changed' THEN 0 ELSE 1. By doing this, we have given 3 numbers to ourselves (-1, 0 and 1).    Then you go to NUX and create the view you want to publish. You'll see this option: Click on the line item you want to use CF on, and then click this option. Rest is pretty straight forward, you select the number formatted line item that will drive your CF and select the colors against each number:     ... View more

Hi @Adejimi    Good thing is your formula is correct, no problems there.  Anaplan is extremely logical so when something doesn't work, it usually guides you where to go. In this case since code isn't showing up and your formula is correct, you can be sure that code is not present in the Country Flat list.    The csv to be imported has three columns, make sure when you are importing into the list, you are mapping name to Country Name and code to Country code. I can see you have mapped Country code to name in the list (This would've happened since you did not change the import mapping and went with the default).  Country Code Country Name Parent US US AMER CA Canada AMER MX Mexico AMER BR Brazil AMER GB UK EMEA FR France EMEA ES Spain EMEA DE Germany EMEA IT Italy EMEA AU Australia APAC NZ New Zealand APAC IN India APAC JP Japan APAC     Note that you'd need to delete all items from Country Flat list first and then re-import to ensure you get the data right.  ... View more

Hi, AD02 Will be a formula driven module. and will be driven by the 3 override line items in INV01. E.g. Submit Purchase Order - Write will be something like 'IF 'INV01...'.Submit Purchase Order Request THEN TRUE ELSE FALSE'. You can also get rid of IF THEN ELSE since Submit Purchase Order Request is a boolean itself. The Override Amount - Write will be something like 'Submit Purchase Order - Write' AND 'INV01 Inventory Ordering'.'Override Suggested Order Amount'. Same drill for Override Method - Write Then you need to ensure you have the DCA setup on right line items. The idea is when 'Submit Purchase Order Request' and 'Override Suggested Order Amount' Boolean are checked, you should be able to see values in the next line item, i.e. Override Amount. Same with Override Shipping Method. When checked (along with Submit Purchase Order Request), you should be able to edit Override Amount and Override Method line items. In Short, your first DCA should drive the two override booleans in INV01 and the next two need to be on the respective next line items. ... View more

This method worked great. I now have my desired graph. Thank you so much! You really saved me. I just have one more question. This method could help me with another task I am trying to accomplish. Dealing with the same list, is it possible to assign the filter to higher items in the hierarchy? Referring to your example, I still want to apply the filter to P1, P2, P3, etc but I would also like to add the filter to lets say Total Products (all in the same module). When doing this method, I can only apply the filter to the lower classed items in the list.    What I am trying to accomplish: In my products list I have P1 Product Lines, P2 Product Families, and P3 Product Names. The first graph I made was great and shows the slots used by each product. Now I want to show slots used by product families. Easy, already made the graph, however, there is a list item in P2 called "other" which is too hard to explain but essentially I want to remove 'other' from the graph by multiplying all the other families by a factor of itself. Hard to explain but this chart should explain better.  'New Slots' = Slots*(Slots/(Total-Other)) The reason I am having trouble doing this in Anaplan is because you can't reference 'Total' or 'Other' in the formula box since they are list items and not line items. If this method works for this, I could assign a line item 'Total' to the highest item in the list which is 'Total Products' and do calculations that way.     ... View more

Thanks Ankit! ... View more

Hi @rob_marshall    Yes and thanks for the ideas. I have replied to Ankit in the previous post whereby I managed to do the find text process. Now I am a bit stuck at turning around the lookup thing. Any idea would be greatly appreciated!     BR Tingting ... View more

@khoonks : The purpose of FINDITEM function is to transform a text into a list element. It is up to the model builder what TEXT to use as a parameter in the FINDITEM function.    If on the same row of your data, you have values only in one of the 3 columns: Column1 or Column2 or Column3, you can use the concatenation: Finditem( List, Column1 & Column2 & Column3 )   If on the same row, you can have values in more than one column. then you will need to create a priority between column1, column2 or column 3 to choose what is the value to be used in Finditem.    Hope it helps Alex   ... View more

Hi @JEEVAK    Essentially if you are using a formula for line item , you would not be able to manually input values , however if your module uses native versions , there is a possibility that the formula can be restricted to be applied to only particular versions (Actual , or current ) etc. Meaning that for the other versions where scope is not applicable , values can be entered manually   ... View more

Is it possible to create a list out of the text(Position 1, Position 2...)? I am not sure if you can get the desired result without that. Anaplan does not do mappings basis text ... View more

Thanks Ankit, the problems are solved. ... View more

@ankit_cheeni  I guess they have posted this in nov 2021 or Jan 2021 ( NOT SURE due to date format) but today when i got my anaplan MB Certificate with the link provided by @AntonMineev I already had it done with the date of certification on it. You can refer my screenshot below. Therefore, as my certificate is expiring at the end of this year, I might need to take up for the re-certification exam at the year end. I guess I need to write to the support team for this!!   Regards, ... View more

Your Hierarchy is called P2 Product and you are writing P2 Products in the formula. That is a misspelling. Also, your mapping is incorrect - you have mapped line items to column 4 but that shouldn't be the case (Size is one of the line items, not the column where all line items are). Check that as well once.  ... View more

@ankit_cheeni    I am not sure what could be the root cause. Just check if all the modules have the same view and no dimension was re-pivoted or moved from its original place ... View more

Hi Ankit. CAL001 is the calulation module it references the REP001 value and outputs it. ... View more