Hi, I want to be clear about the definitions of different properties of Lists. These properties are - Referenced in Applies To, Referenced as Format, Referenced in Formula, Next item index? Could you …
Hello All, Am I the only one surprised by the new blueprint view (the order of columns has changed) and not being able to find any info on Anaplan community?
Does anyone have any additional information on the upcoming release on 4/24 that will allow for calculations to be driven by the User list? This sounds very intriguing, so any intell would be greatly …
Hi Everyone, I have two modules A and B. The module A has one line item formated as a list "Users". Let's call it myUser. The module B's dimensionnality is Users (only). It has one boolean lineitem ca…
Hi all, I have some data with various dimensions - one of which includes 'Colours'. I've also got a matrix between Colours and Cities separately (e.g. in the attached) which allocates Colours to Citie…
We would like the ability to import current period into the time setting. Currently, models need to be rolled over month by month. If we could automate this process, we would have less maintenance deb…
Hi - I have two line items, one specifying the weight and the other, say growth. For easy calculations, let's presume that the Weights and the Growth values are manual input. Growth is a manual input …
Hi hope someone can point me to the right direction. I have a module which Dimension by Agreement Number (xxx1, xxx2 etc) Timescale by month (Jan 19, Feb 19 etc) Line item :Start date : (when the agre…
Hi, We need help trying to write a formula for a value to show on only every 10th of a given month. Also need to consider that the weekends do not count and would fall into the next business day. For …
Hi, We are trying to pick up a Line Item Balance from the previous end of the month. For example, for the month of Feb, need to see the ending balance that is at the end of January.
Hello, I have run into an issue for which I could not find any documented limitation or bug, but I think I may have hit one. I am looking for a solution to the following scenario: Let's say I have a c…
Hi, Need help creating a formula that pick's up the moving average for a number within 6 business days. Example) The amount for a line item over the past Weekdays were 1, 4, 6, 8, 9. I want to forecas…
Dear Community, I have a question related to import transactional data (Net Sales) into Data Hub, with the following requirements: * The Net Sales and Qty Volumes are grouped by more than 10 attribute…
Hi, My numbers are slightly off from the Example Model. (I believe like 2 units off). Attached is my Blue Print view and Grid View. Please advice. Thank you
Hi, Hope somebody can assist me please so I can progress further on the exam. I am completely stuck after exhausting all options this morning. I picked Column 2 Departments - map to E1 Departments I p…
POWER function is unable to calculate all equations correctly. Cube root of '-8' is '-2' But when I tried the "POWER(-8, 1 / 3)" calculation, it resulted as "NaN" (shown in Image)
Can First Non Blank formula be used for numbers as mentioned. When i try to, i get an error as follows, Let me know if you are able to successfuly use this formula for numbers. Thanks Arun
POWER function is unable to calculate all equations correctly. Cube root of '-8' is '-2' But when I tried the "POWER(-8, 1 / 3)" calculation, it resulted as "NaN" (shown in Image)
Hi there, I have a list dropdown for our users to select from. However, I am wondering the best way to "hide" certain list items. I want to ensure users don't have the ability to see or select an inco…
Hi Context : In Model Calender, Calender Types reflects 3 different options like a) Weeks: 4-4-5, 4-5-4 or 5-4-4 b) Weeks: General c) Weeks: 13 4-week periods In exl there is "weeknum" to interpret th…
Hi, I'm trying to create a line item in the target module that pulls in the values from the source module given a certain day. Attached are screen shots of the modules. Please advise. Target Module So…
We use ISO calendar split. This mean that a year contains about 52 calendart week and about 63 shared weeks: when a week is located in two months at the same time. This is the only way to move back an…
I need to be able to lookup off a unique opportunity code for line items in a module. Below is the code I need to look up off of, the list is titled MEC Opportunities In this module, I need the line i…
Hi, If i have 20 line items in a view, i have to conditional format everyone, would be a great idea to be able to format ALL line items using a single line item reference?
Hello, I recently had to restore data in an ALM environment. I had to create a New Prod model by copying/archiving Old Prod. I took Old Prod out of deployed mode to capture the data I needed to reload…
Hello community, I have a question concerning the task "Import Shipping Expenses into OTH01 Module" included in the Level 2 conclusion. The preview of the import doesn't show the numbers of the shippi…
