Hello, I'm trying to import Weekly Safety Stock Csv file into the DAT04 Distribution Center Parameters Module. I'm not sure if something is wrong with my mapping, because I'm not getting any error, th…
Hi, At present there are no Options to Highlight / Color the Headers (Row / Column) in New UX Board View or Worksheet view. Since on a board I have approx 100 line items which are further segregated i…
Hi Team, Looking for some guidance on L1MB Activity 5. I built the following code: IF Employed? THEN Salary * 'EMPO3 Employee Drivers By Role'.Bonus %[LOOKUP: 'SYSO8 Employee Details'.Department, LOOK…
Hello Everyone, The values for 'Revenue and Cost of sales' are not appearing in the REP02 Size Margin Report Module. Please find attached screenshots for your reference. Please help me.
As a model builder I want to have the option of hiding the entire process details when running a process so that the user experience is simplified, where possible. For example : we might have a number…
Hi Anaplan expert, The module below has a numbered list and some line items. The formula on the Max Date field is Date[MAX: Date]. I didn't get any results. Could you please tell me how the formula to…
Hello, For the creation of UX Prototypes in Level3 MB, kindly suggest how to start designing the UX. For Assigning to Accounts Territory I am unable to design. Please advice. Thank you, Sneha.
Hi I am having a module with Products list as dimension and Users(Default Users formatted), Status and Boolean(Target Line item) as line items. I need Boolean to be checked for the Products wherever U…
Hi Community, If regional sales executes adjust an accounts data manually, then should we adjust the remaining accounts targets in an proportionate manner to meet the overall country target? Is that a…
You can now toggle the model source within a page in New UX. There's no easy visual way to know if you are in your Dev or Prod environment. Having the ability to change Anaplan default blue color sche…
I cant seem to remove the entry (sales) in the department row so that it can reflect exactly what was given in the example. Please how can I resolve this?
Hi, I use week General as Time setting. I want to get Last day in all time. Module A Time2021/1/12021/1/22021/1/32021/1/42021/1/52021/1/62021/1/7Num1111111Offset(Num,1,0)1111110Last day 2021/1/7 I can…
I want to aggregate the order From Table A to B. Table A RegionProductamountax100 y10bx200 y20 Table B Regionaggregatex300y30 I input the formula as below. Aggregate = Amount [SUM:Region] But I could …
My source module has no dimensions so How do I use lookup to transfer my data to result module. My Source file My Result module Data should onlu inserted in ABS not other two.
Is there any way to get back on track. I think since I didn't get the right set up for the Activity 5, All of my answers have been wrong since even though I am adding new modules. Do I have to scrap t…
In the new modelling experience, when expanding the formula bar to display the whole formula in the new formula pane at the bottom of the screen it goes straight into 'edit' mode. This means that if y…
Hi, I want to use aggregate function. I want to aggregate "Date" Lineitem from Order A&B to Aggregation Module. Date Lineitem has Date format. I use " OrderA.Date[Max:Product]" as Formula. And I can a…
Is there a way to sum data in a ragged hierarchy that will only be used for reporting? My source module is a Data Load module with all my GL transactions. The target module will be an output report d…
Hi, In a module I had a list (A1,A2,A3,A4) and a line items Value,type(list formated line item),change value if two list items has same type and status as inactive then change value for inactive list …
I am having an issue that I'm not sure is able to be solved, but wanted to ask the community to see. I have a hierarchy as follows: Top Level = Total Company BU L1 parent = Total Company BU L2 parent …
Hi Anaplan Community, I have a strange behaviour in Anaplan. I use finditem in 4 different line items (Site 1, Site 2, Site 3 and Site 4) . The finditem formula is similar for each line item, it just …
Hi Community, I would like to ask question, since I have not encountered this matter before. Below is a sample report with indention and Summary style. In this sample report, the items on the row are …
Hi, Trying to create a Line Item in my SYS Time Setting Module that filters out all of the Business Holidays that we are not operating. This is a Daily Model and not sure how to approach writing the F…
Hello all, I am stuck here for more than 4 hours trying to figure out why my numbers are different but unsuccessful. Can you please help advise? Mine: Anaplan's Much appreciated!! Daisy
Hello, Requirement :- The parent should have the average color of its children. I have an Indicator(Red , Yellow, Green) coming as a Text input from the Source. The requirement is to roll up to its im…
