About neg177

neg177

Hi, I have a question on the LI "Initial Country Sales Targets" in Module TAR01 Detailed Sales Target. For this line item I'm assuming that we are pulling from the TAR01 Sales Targets where the initial country sales targets are calculated. Would I then use my SYS03 Module to SUM by Country and Product? Below is a screen shot of my LI and current formula. Thank you

neg177

Hi, I need help on knowing what are best practices for inputting percentages that are assigned to each item of my list. I do not know if I should do this as a Module, or should I just create a List Property that holds the percentages? Thank you

neg177

Hi, Need help on how to set up a formula for a LI that will pull from another LI every other Thursday? Thank you

neg177

I will reach out! Thank you so much

neg177

Hi, I have been using Anaplan for a year and a half now and would like to know if there is actual training with another experienced Anaplan Trainer available? This has been a very much self taught journey and I have learned a lot, but there are certain model building skills and tricks I feel I would need to learn from an experienced builder verses trial and error by myself. I would like to know if there are live or one on one sessions available when it comes to learning model building in Anaplan? Thank you

neg177

Hi, I currently have two different Data Sources in my Model (D01 & D02). They both share a MID and a CID that can link the data together. I need to be able to look up my data in my D02 Module by a List named Legal Process. I'm having difficulties making this List match the data in my D02. I know I can potentially create a "mapping module" to link the data together with the List, but wanted to know if there is a way to do this in my D02 Module verses doing the mapping module. (Let me know what pics you would need to assist) Thank you

neg177

This is the error I get if it is a numbered list. The Module will not allow me to add the G2 List as a Dimension.

neg177

Hi, Thank you for your response. G2 is not a Dim of the Module and I understand I should not have that as a dim of the Module. I also have tried to format the Line Item as a Text and the use CODE('G2 Country') to bring in the Code of that list but still not working. I believe it is something wrong with the G2 List, because I tested it with the P2 list and this formula worked.

neg177

Hi, Thank you for your response and that makes sense and that is what I thought as well, but when I use the formula below it still does not work. Formula: CODE(ITEM('G2 Country' ))

neg177 · ‎12-20-2021

Thank you so much for your help. Your awesomely awesome!

neg177 · ‎12-20-2021

Yes Almost there lol, thank you so much for your patience. I have used both the Y-M-D and YYYY?MM?DD and still getting the same error with both. Its just that error saying "Expected 2 or 4 digit year in date/period".

neg177 · ‎12-20-2021

I believe I have my time set correctly now, but I still get the following error below. The data is still getting loaded into the Module, but I need no errors at all because we are trying to create a OneCloud connection and we need to make sure our mappings have no errors for this. Thank you

neg177 · ‎12-20-2021

My apologies, I was trying to map to the Target and not the Source like you said. Now I just get this failed error...

neg177 · ‎12-20-2021

still getting same error when I customize the date setting.

neg177 · ‎12-20-2021

Hi, I'm currently having mapping issues with the current Flat File I'm trying to load into Anaplan. It is saying it can not match up the dates, but I'm hoping I will not have to manually change the dates on my flat file verses getting a way for Anaplan to read the dates to map the data. Please advise. Thank you

neg177 · ‎12-19-2021

Hi, I'm having alot of trouble with the LOOKUP formulas for this module. I'm trying to bring in my DAT01 Actuals into the TAR01 Module by Country and it is not working. My dimensionalities are correct and all, but I think it has something to do with my G2 List. I have been trying to figure this out for 2 days now and stuck. Please help. Want to add G2 Country LI from SYS03 Module and it is not allowing me to. My G2 List I cant pull in to show in my Module either. Thank you

neg177 · ‎12-09-2021

I wanted to pull the Country's straight from the SYS02 Country LI's, but dimensionality gets in the way and I get an error. I'm not sure what text string I would use unless I created one.

neg177 · ‎12-09-2021

Hi, I do not know why my G2 Country will not display the Country names in my G2 List. Please advise I have trouble shooting by adding a properties to help display the names and then calling upon that in my formula and that will not work, also I tried calling upon the Code and that doesn't work either. Please advise. G2 List Thank you

neg177 · ‎12-09-2021

Hi, Thank you this worked perfectly!

neg177 · ‎12-08-2021

I'm having this same exact issue. Where you able to figure out? Thank you

neg177 · ‎12-08-2021

Hi, I have been trying to trouble shoot populating my P2 Product LI in the SYS03 Account>Product Details Module. I have the LI formatted as a List for the P2 Product List and using the formula FINDITEM('P2 Product', ID), which will bring in the ID associated with items in my P2 Product List. I do not know what I'm doing wrong to not populate the LI. Please advise. My P2 List Thank you

neg177 · ‎12-08-2021

That worked, Thank you

neg177 · ‎12-07-2021

Hi, I have tried almost everything and have been stuck on this part of the model build or a day now. I have changed my dimensioned and tried to get them to match and still not working. I'm trying to pull in Actuals from the DAT 01 into the DAT02 and Looking up LT Account A1 inthe SYS03 Module. Please advise. Thank you Formula: 'DAT01 Historical Data'.'2019 Actual Sales'[LOOKUP:'SYS03 Account>Product Details'.'A1 Account'] Dimensions of DAT02 Dimensions of SYS03

neg177 · ‎12-06-2021

I do not have those options in my mapping

neg177 · ‎12-01-2021

Hi, We are trying to create a formula that will subtract the sum of all the List Items, (excluding List Item 'Other'), from the overall Total of all the List Item totals added together. We were thinking of using the SELECT function to pull in the amounts for each List Items and then summing those all together in a SYS Module and then pulling in the result to our main Module. Please advise how this can be done with Anaplan best practices. We would want the Above Formula to be subtracted from a sum of all the other List Item Amounts. Thank you

neg177 · ‎11-30-2021

Hi, I'm having problems importing data from my Level 3 Model Building Data Hub into the other Level 3 Model's List. I need to Import that from my Module SYS14 Create Account> Product into the List A2 Account>Product. I created the LI's in the Module in the List as Properties, but I'm having trouble pulling in the data from the Module. I get a error when it comes to the mapping of the data. SYS14 A2 Accounts>Products List Please advise, Thank you

neg177 · ‎11-26-2021

Hi, Need help on how to count the number of times a Text dimension LI shows up under a List LI. We have tried to use the SUM function as well as LOOKUP function, but they did not work. For Ex) We would want to know how many "Merchant Id's" are under each individual 'Legal Milestone" Below are snap shots of the two line items and modules we are trying to complete this in. The Formulas we have tried are below: Merchant ID [ SUM:Legal Milestone ] Merchant ID [LOOKUP :Legal Milestone ]

neg177 · ‎11-18-2021

Hi, Need to know how to get a date to show for a line item that is dimensioned by time, but the module is not dimensioned by time. The formula is working correctly, but can only see the result in a subsidiary view. Need to know if possible how to get the result to show when the LI is not in subsidiary view. If this is not possible would like to know a work around. Subsidiary View Below Thank you

neg177 · ‎11-17-2021

I got it to work. Thank you

neg177 · ‎11-17-2021

It will not take the URL directly and also I tried to save as a PNG, but takes me to the image pasted below. Not sure how to make this into a link to put into my LI. Thank you