About JussiLi

JussiLi

Hi @johan.marketoft, I would use YEARFRAC function for that. And put it inside ROUND function to get the number of full years. I case you want to compare employee start date to current date that might be trickier because Anaplan doesn't have a function to give you current date (like NOW() function in Excel). You need to import current date from outside Anaplan. Best regards, JussiLi

JussiLi · ‎09-19-2020

Hi, You probably have 'All Roles' as a list member in E3 Role list. Regards, JussiLi

JussiLi · ‎09-19-2020

Hi @rmat066sysf, YEARVALUE function is automatically retrieving year value from the source. It doesn't require (or even allow) LOOKUP function to be used with it. Regards, JussiLi

JussiLi · ‎08-23-2020

Hi @CommunityMember131921, You should modify Labels tab in Export to be able to export both name and code. Regards, JussiLi

JussiLi · ‎08-22-2020

Hi @yangsmith , Segment field was already populated in my SYS02 Account Details module when I downloaded the model. Regards, JussiLi

JussiLi · ‎08-14-2020

@Gita , This is default message Anaplan always shows when you change the format of line item. Just go ahead. Regards, JussiLi

JussiLi · ‎08-11-2020

At least that was my assumption when I did the exercise; I assumed that in this exercise "source system" just has different naming for it which user needs to notice. And without manual mapping Utilities won't be populated at all. In real life you can check it from data experts. Regards, JussiLi

JussiLi · ‎08-11-2020

Hi @Scorina , I think that .csv file has different name on purpose, to check if user notices that one item is not automatically mapped and it need to be mapped manually. Rates should be mapped to Utilities. Regards, JussiLi

JussiLi · ‎08-09-2020

@tgovekar , Safety Stock exception value is high in All Products level at this point because Forecast Demand is consuming the inventory, but Purchase Order Requests haven't been submitted, except for maybe Nutzo Bar_EN. Your values looks ok. Regards, JussiLi

JussiLi · ‎08-05-2020

@CommunityMember111277 , I would use separate module which stores the number of accounts data: and bring account count data back to main module and use it in conditional formatting: It is possible to replace separate 'Account count' module with a line item which has Accounts as a dimension and use same IF statement there. But it is best practice to avoid subsidiary views. Regards, JussiLi

JussiLi · ‎08-05-2020

@CommunityMember111277 , One way to do it is to use RANK function. In this example 'Account occurrence' line item shows number 1 if account occurs more than once. Then conditional formatting is used in Accounts line item. This doesn't mark the first occurrence of account, but all other (second, third,...). Regards, JussiLi

JussiLi · ‎08-05-2020

Hi @Maggie , Forecast demand 2050 in Week 2 FY20 is correct in my opinion. The review of INV01 module shows 2050 (pic below). In DEM03 module Candyate was overridden from 60 to 62, as you said. Therefore it is 2050 and not 2048. For some reason product replenishment dashboard activities shows 2005 for Week 2 FY20. I came to conclusion that it must be typo kind of thing and didn't bother about it. Mainly because INV module was reviewed already in earlier stage. Regards, JussiLi

JussiLi · ‎08-05-2020

@hyudolee , Formula you mentioned "Table A.amount[SUM: Table A.'Model.Line'] " should work in Table B when you fetch amount from Table A. Factory line item in Table A don't prevent this from working. Regards, JussiLi

JussiLi · ‎08-05-2020

pratyaksh.dua@polestarllp.com , Txt seems to be only file format when exporting History. One possibility is to open txt file to Excel and then save it in csv format. When opening it to Excel choose Delimited and use Tab as a delimiter. Regards, JussiLi

JussiLi · ‎08-04-2020

Hi @Dawsonc , Problem can exist somewhere else as well, but let's check "Role" list first. Role list doesn't have parent hierarchy, but it should have Top level. (More information about Top level item and Parent hierarchy https://community.anaplan.com/t5/Best-Practices/Top-Level-Item-and-Parent-Hierarchy/ta-p/56249). Top level should have been automatically created when list was updated from Role.csv file. The file contains fields: role, parent and code. Regards, JussiLi

JussiLi · ‎08-04-2020

Hi @Dawsonc , Technically the locations of list doesn't matter, but it's good to have it among other related lists (employee lists in this case). Easier to find. Is your "Role" list populated or is it empty? Regards, JussiLi

JussiLi · ‎08-04-2020

@kunal_311 , The chart looks like yours, if no purchase order requests have been made. If you select same 'Submit Purchase Order Requests' as in the sprint example (see pic below), your chart should be similar. Regards, Jussi

JussiLi · ‎08-04-2020

Hi @kunal_311 , In my opinion "Chart 01" is correct in terms of publish method. You just need to adjust its dashboard setting so that all months are available for selection, not just Jan-Jun 20. Regards, JussiLi

JussiLi · ‎08-03-2020

Hi @kunal_311 , Try different publish method. Read the instructions carefully. Regards, JussiLi

JussiLi · ‎08-03-2020

Hi @bleeds , I think you need to recheck the logic of the first week of timescale. Regards, JussiLi

JussiLi · ‎07-31-2020

Line item formats are correct. After the start " IF NOT Override Shipping Method OR ISBLANK (Override Method)" you have THEN and ELSE statements. Do both line items that are mentioned after THEN and ELSE have 'Shipping Methods' format?

JussiLi · ‎07-31-2020

@bleeds , The logic in your formula is correct. It is missing one part (see following picture), but it's not the reason for error message. I think format of one line item is incorrect which is causing error. Regards, JussiLi

JussiLi · ‎07-31-2020

Hi @bleeds , You should use the same list. There seems to be a typo in sprint instructions. Regards, JussiLi

JussiLi · ‎07-31-2020

Sorry, I somehow missed that part. I modified the logic a bit. Now when user selects parent, all its descendants are selected. Also if user selects one of the Child_2 members, only that particular member is selected, not all Child_2 members. If all Child_2 members should be selected, formula can changed for it. Regards, JussiLi

JussiLi · ‎07-30-2020

Hi @clarashao , As @VIGNESH.M suggested, remove the first mapping. Leave it blank, don't select Column headers. Regards, JussiLi

JussiLi · ‎07-30-2020

I modified Fruit module a bit. It's probably more logical this way.

JussiLi · ‎07-30-2020

@Rajasekhar , There can be simpler solution, but following works at least with this kind of short flat list. There is one technical module (Property A module) in addition to main module (Fruits module). Property A module tells what is the descendant of each flat list member. Downside of this solution is that this additional module has to be maintained. But if your flat list is stabile, it is one time task. Blueprints: List 'Property A' is used in both above modules.

JussiLi · ‎07-29-2020

Hi @Sravan_Kumar , For me the combination of ctrl+alt+Enter (all 3 pressed at the same time) works ok. Below is sample text box I created. The text is from Anapedia page (https://help.anaplan.com/anapedia/Content/Dashboards_and_Visualization/Build%20Dashboards/Adding_and_Styling_Text.html)

JussiLi · ‎07-29-2020

@Sravan_Kumar , In the second picture; if you place cursor before word "Below" and press Ctrl+Alt+Enter (on PC), it should move text which is after the cursor, to next line. If you want blank line between paragraphs, just press Ctrl+Alt+Enter again.