-
Retrieving user selective access in module
Hi, I have an issue in my Workforce Planning model I can't quite get my head around. The scenario is the following: I have an organisational hierarchy with Cost Centers and then Individuals as childs. I have selective access enabled to my cost center list and only certain users have access to certain cost centers (and…
-
Getting Monthly and Quarterly totals in Weekly model
Hello all, I'm building a model with a weekly time scale. The client wants to see the Monthly and quarter totals also. Do you have any suggestions on how to get these totals? I created time filters to get a Month and also manually did a Quarter line item. But when I do a lookup, it doesn't come through.
-
Putting values in territory field from multiple quota assignment rows of an employee into one field
Hi Experts, Appreciate your brainpower on below challenge. Using below test employee as an example, we would like to have a field show “PKI, BCT” in the same row same cell, similar to concatenate or textjoin in excel. Expected result like below (using excel as demostration) Thanks a lot!
-
Is it possible to have a "Create" Action on a list with no parent?
Is it possible to have a "Create" Action on a list with no parent? If not then is there a workaround?
-
How to Auto-hide line items
I have a table which include value from Q1 FY21 to Q4 FY23 as line items, and want to hide which the value is 0. But when I use filter on line item will hide other line items like KPI Name (it is TXT format). How can I hide these line items which value is 0 and does impact other no number format line item? Thanks!
-
Display months as M1, M2 instead of Jan, Feb
Hi! My company uses a 4-4-5 work week calendar. Currently, the system shows the months has Jan, Feb…Dec. but I would like it to display as M1, M2….M12. The reason being is that our M1'23 has a date range of 12/31/22 - 1/27/23, therefore, saying Jan is misleading. Thanks for the help!
-
Can you link to a specific record on a new UX page
I have a list of projects and i have a line item that is a link to the project page, but would like to go to the specific project they are clicking on. The html for the page is the same no matter what the item, but can you add a tag to the html at all, like you can in other apps?
-
Import Sources
Hello Anaplan community, There are several notions related to import sources that I have trouble comprehending. These are : Source Labels, Source object, Source model (in Actions) and Source models. I can not understand what each term means, what is the difference between them, how should I manage the import sources in ALM…
-
Sum from a model Applies to Fiscal Year and a customized numbering list to another w numbered list
Hi Experts Appreciate your prompt help to provide a solution! We are working on Quota Management based on Territory hierarchy. In module A (Applied to Fiscal Year, Mapping List with items like PSM1, PSM2, ..PSM1600), users can assign different territories to one employee assignment (employee assignment is not the same as…
-
DCA by User´s role
Need to generate a DCA module that depends on users role. I have seen that there is no capability to extract the users role, any suggestions? br
-
Add the current user to a field when they approve an item
I have an approval process with several gates, i have restricted to ability to approve, but all i want to do is when the approve button is pressed is apply the current user details to the Approver and add Todays date. The date part is done, as I already have the date automatically updating in all models. How can i get the…
-
Add List Search Option while create module and Import from Existing Model
Hi Team, If we provide a search option to select a list when creating a new module, it helps model builders select the required list. Similarly, if we provide a search option to select the source for any import from existing model views or lists, it also helps model builders.
-
Schedule of CloudWorks only working days
Hi, I want to run process on 1st Working days in CloudWorks. If I want to do this, I should use CloudWorks API? Month First Working day 4 3 5 1 6 1
-
Conditional formatting between range of numbers
Hi Anaplaners, I have 5 line items (Number Formats) showing variances. I want to apply a conditioner formatting to each of the 5 line items based on a range of numbers. E.g any numbers between -1500 to 2500 should have a Green colour and any numbers outside these range should get a RED colour . Please is there any…
-
Fix Window like Excel in UX
Hi, I want to use fix window function like Excel in UX. I want filter card to always located on top of the page. Is there any way to do this?
-
2.4.8 Demand Review UX Page
Hello, On my pages for DEM03 Demand Forecast I want everything on one page from top to bottom. It will not let me move the menu's on the right side into main screen. Any idea how to adjust this ? Dragging into boxes highlighted does not change anything.
-
How to fix summary settings for hidden cells
We have read access on months we don't want people to see, however the summary for the whole year will still take the sum of the hidden cells. We don't want to remove the yearly summary or zero out the amounts until they are ready to be seen as that would cause issues on our end. is there a way to summarize only cells that…
-
Activity: Import Data into FP&A Model LVL2 Conclusion
I am trying to import the information from the INV05 Module but get items failing. This is my save view, how do i make for the G3 location list only show me the lowest level of information without the country and region? Thanks in advance
-
Production Capacity Module_Factory 2
Hi, Does anyone know how to build a calculation module in Anaplan that calculates production capacity using the formula bellow, and includes the option to check whether the factory is working on weekends: This is the formula I am using: Production capacity = number of machines*number of working hours*number of working…
-
3.3.5.6 Update Inventory Ordering to Calculate Shipping Costs
Hi all, I'm having difficulties with the Shipping Cost line item. I am getting an error on the formula below…Can someone kindly point me in the right direction Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: Shipping Methods]