Hello, I have a module (image below), how can I create a line item where all items will be max value from 'New Store Num' where 'To many Stores?' is True . For Example in image below it will be 8.
Hi @KacperSzafranski13 , This can be done in following steps: 1. Firstly create a line item say 'Store Num for target Scn' Which will simply bring the values from 'New Store Num' where 'To many Stores?' is True by adding simple IF THEN ELSE statement in the formula and change the summary settings to Max for the same. 2. Create another line item say Max value which will contain all the dimensions as other line items have but remove the dimension you have in column(which has Items as 1,2,3,4…) and in formula simply refer the previous line item you build in previous step, and then you can refer to this line item in your final Line Item 'Target Scenario' to get the max value in same dimension. OR 2. you can simply select that the top level summary value to the final line item 'Target Scenario' using a formula as- Store Num for target Scn[SELECT:1234list.TopLevel] I hope this helps.
Hi, I need help in pulling a specific view in Anaplan XL. The first grid should display attributes of various projects, while the second grid should present the monthly financial data for these projects. Thanks in advance.
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
