About Kanishq17

Hi @ifeldman  Just use DATA02 Input volume.volume as formula in the rev02 line item as it is direct reference ... View more

@ifeldman  Hi, I believe you can directly refer from the input data module as there dimension is at P3 SKU and target is at P2 product, so since P3 rolls up to p2 , the value will automatically be aggregated so use input module.line item in REV02 ... View more

hi @Rajasekhar  You can assign A+B as parent of A ,B items, it will automatically sum up else you can use sourced.value[select item.A]=[item.B]   ... View more

hi @aeyzat    Create action works for numbered list, for general list, you can publish the grid view list to the dashboard , and there + icon is there to add items, Alternatively you can try this 1. Create a dummy list with 1 item 2. create a module with that list as dimension, add name parent code line items as text formatted , and add name , parent or code for the item you want to add to the list 3. create action to load list from that module,map fields accordingly 4. Create action to clear the module 5. combine the 2 actions to process and publish to dashboard here add is a module with dummy list, line items I added name and code of new product to be added to the list, items is the general list i need to add items to, This is process I published, first it adds item from module to the list, then clears the module so that it becomes blank and new item can be added,  After running , you can see, the module is cleared and item 9 is added to the list   In order to delete item from list, delete from list using selection is an action available in anaplan, which enables to delete list items based on boolean, create a module with the list as dimension , add a boolean delete?, and edit the action to delete from list based on the boolean , then publish that action to dashboard   hope it helps   ... View more

hi @Joh04924 You need to check the dimensions at source and target when using LOOKUP, so you see in source there is P1 and in target there is P3, so need a mapping between P3 and P1, so in the SYS module we get the P1 prod family for P3 SKU using PArent(parent()) , now based on the mapping, you can lookup values from dem02, so it will be dem02.lineitem[lookup:SYS08.Prod family]   ... View more

HI @praba71  s @anirudh mentioned use isnotblank(code) to identify nonblanks and then use Is first occurrence on those else keep true  ... View more

hi @praba71 , you can use isfirstoccurence to find unique code as then make a filtered view and then load in the related downstream models which contain the list as a dimension ... View more

@hkitograd  mapping used in 3:42 is correct as name will map to country list, and then in line item mapping, check that mapping is established else manually map Code-Code and region-region, also go in subesquent tabs of country to check mapping ... View more

@l.bourgonjon  Alternatively you can create a flat list of the periods you want to enter comments for, then enter comments against the flat list and the accounts dimension, then map those periods with time dimension in another module, then aggregate the comments using textlist or your method also will work fine of creating 2 separate grids with different dimensions   ... View more

@Sravan_Kumar  For text , SUBSTITUTE function is there which enables to replaces a portion in a text line item with a new string, to replace numbers, you can convert into text using TEXT(), then substitute , then convert substitiuted text into number using value()   https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/SUBSTITUTE.htm   ... View more

@Sravan_Kumar  Can you elaborate more ? ... View more

For using SUM, create another list with only items you need i.e ones and in that module create a ine item list formatted to the new list and then establish mapping , then in the target use count[sum:mapping], But this will require a new  list  ... View more

Anyways In case you need to have multiple items with same name, you need the list to be a numbered list and keep a display name property which will allow you to rename items   ... View more

@Sravan_Kumar ,  But you need count to be aggregated , so instead of keeping multiple , use only 1 item  ... View more

@Sravan_Kumar  If it is a general list , Orange2 cannot become Orange1 as duplicate entries are not allowed, so you can only keep the 1 entries, then delete remaining items and change the count in the source file and then upload again ... View more

You can create a action to delete the list using delete using selection action, in the boolean you specify which list items you wish to delete and then reupload the file with the new items, if you load the new file, anaplan will update the count for matching items and not delete the existing list   https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Actions/Other_Actions/Delete_from_List_Using_Selection.html   This will help you     ... View more

@Sravan_Kumar    Hi, Can you provide more clarity as to what you need, do you need to reload the list with the new items or in the existing list, create a subset and aggregate count based on same name?     ... View more

hi @Rajasekhar  what is the relation between X and List B, is X also present as a property in list B? ... View more

hi @Rajasekhar  You are using native Anaplan Time dimension in the page selector which is selected to FY19 but your module is dimensioned to month, since default summary for line items is none, you wont see any value at FY19 which is a time summary , in case you choose any month like Jan 19 or feb 19 in the dropdown, you will be able to see values, hoever I think you do not need time dimension in this case, so you can set time in blueprint view to not applicable ... View more

hi @samlambert    i think this may help you https://community.anaplan.com/t5/Best-Practices/Using-Python-3-with-the-Anaplan-API/ta-p/33150#toc-hId-1331102735   ... View more