About JussiLi

JussiLi

The ability to open lists in own tabs is something I have waited for. That's my favorite. Toggling between modules and lists have been somewhat annoying earlier.

JussiLi

Hi @sosunkwo, You can have separate modules for percentages and calculation. In this example I have percentages in Project percentages module: Calculation module Labor fetch percentages from the first module and calculates Final labor. I added top level to 'Project complexity' list. Hopefully I understood your problem correctly and this helps. -JussiLi

JussiLi · ‎03-30-2021

Good to hear. Happy to help. -JussiLi

JussiLi · ‎03-30-2021

@seanomahoney, Open DEM01 module and its blue print, and check that also line item has month as time scale. Best regards, JussiLi

JussiLi · ‎03-30-2021

Hi @seanomahoney, Check the time scale of your DEM01 module. It looks like it is week, but it should be month. Best regards, JussiLi

JussiLi · ‎03-29-2021

Hi @aadilrafeeque, Check your G1 Region list. If that list is not yet populated it will cause that kind of error. If G1 Region is empty, update that list first before G2 list. Best regards, JussiLi

JussiLi · ‎03-25-2021

Hi @dylancolliflower, Try to use HALFYEARVALUE function. That should work if you need to fetch data from half year time scale module to weekly time scale module. Best regards, JussiLi

JussiLi · ‎03-19-2021

Hi @SeanDW, For FY21 baseline you need to use FY20 Dedault Forecast (marked with green in snip below). For that you have to use IF statement in 'Baseline Forecast' line item; in case of 1st forecast year, take data from DAT03 module, else take it from 'Defaulf Forecast' line item. For 1st forecast year setting you need to use Time settings by week system module. When you take FY20 Default Forecast to FY21 you need OFFSET function so that value in Week 1 FY21 is fetched from Week 1 FY20 etc. Initial Demand Forecast is Default Forecast rounded UP to a whole number: ROUND(line item, 0, UP). Regards, JussiLi

JussiLi · ‎03-06-2021

Hi, @ankitaga2000, Your G3 Location list is missing Distribution center subset. That is the reason why you didn't get this option when you created import action. Please check earlier stage of this course; "Create Geography Hierarchy Lists". Best regards, JussiLi

JussiLi · ‎01-04-2021

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-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