About ankit_cheeni

Hi @Brj73    In your module, you have already calculated Initial Demand Forecast. The intent then is to get the end user the chance to override it. Your 'Override?' line item allows them to check a boolean when they want to add an override right? So this should not be formula driven 'Override Forecast' is where they will add the override number - so not formula driven, just a user input 'Final Demand Forecast' - If your override isn't checked, it should pick up Initial Demand Forecast else you pick Override forecast. So your formula should be something like - 'IF NOT Override? THEN Initial Demand Forecast ELSE Override Forecast' ... View more

Hi, Sorry my bad, Start will importing the csv again. that is where you will see the option. Open your module, go to data and then import - select the csv you want to import and you got a fresh start ... View more

Your data's column headers are in row 2 and data starts from row 3 - that is the first change you need to do on the very first page when you start your mapping   You map the columns that correspond to your dimension:     Make sure your time format is mapped correctly   Make sure you revisit what all went wrong with this import - this is probably the best one yet!   ... View more

Ah! I can see your product codes have been added as line items. Can you please share your import mapping - the first screen when you start doing the import ... 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

I am sorry I don't think I understood your question but I will give it a shot. Since you are creating codes, is it possible to parse out the numeric part of the code and then use MAX to get the latest in another line item (separate module since you don't need the dimensions)? That way you have the latest numeric and can manipulate it as required. Refer back the manipulated line item to create your code. ... 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

Get it to a state where you have both line items for each product Then Create a Line Item Subset of both the line items in MOdule 1.  Create a Filter Module dimensioned by this Line item subset and Products and have one Boolean formatted line item (Say Filter). Then use this as a filter in Module 1. This will make your char view dynamic.    Hope that helps.  ... View more

@davargas    I have a question and a kinda lazy solution if you have or can add a top level to Products. If you do, you can select Slots for all the products and select Max Slots for your All Products, once you have both LIs in your Module 1.    My question is if your Max Slot is not changing with Products (and plausibly other lists too), why do we have them as a dimension in Module 2?   Not sure how helpful this would be and I am sure someone else will have a better solution if this doesn't work.   ... View more

Hi @davargas    I can’t put it any better than @JaredDolich  If you have an additional list in Module 1, you can create a new line item there and the values will just get repeated for that particular list selection, which I assume would be the required behaviour here. You then have 2 line items in Module 1, Slots, which changes with your list selections and Max Slots, which doesn’t change with all.  I have a feeling this is a repeated question which means you’ve been stuck for quite some time. Happy to connect over a call if that helps.  ... View more

Hi @KaF    I do not think time should be a dimension in this module, so you should get rid of it. Go to blueprint and make the highlighted column Not Applicable:   ... View more

@rob_marshall  I did recommend creating separate line items for each FINDITEM, which would replace all FINDITEMs in the formula. Not sure how is that different from what you are suggesting.    Also, if you do ' if isnotblank(col A) then finditem() else blank ' you are assuming that if there is a text, it will be present in the list and then you'd create another IF THEN ELSE to consolidate all 3 columns in one. It would be more inclusive if you do separate FINDITEMs and check on the result of finditem in the final line.  ... View more

Can we just do IF ISNOTBLANK(FINDITEM(X, Col A)) then FINDITEM(X, Col A) ELSE IF ISNOTBLANK(FINDITEM(X, Col B)) then FINDITEM(X, Col B) ELSE ...., X being the list you are finding in. Create separate line items for each FINDITEM, i wrote it all together just for explanation ... 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

@tingtingxia    Uff! I cannot think of a lean solution. What can be done is a mapping module with Strings as one dimension and SAP Extract as another - this allows you to use FIND function to find the name of Strings within the name of SAP Extract.     My concern is this will be a really bloated module and might take up a lot of space.  ... View more