About Pooja

阿宝oja

Hey, Please check the below items: 1. Pivot and get that list in rows then right-click and select "show all", then again move the list to page selector and save the view. 2. If it's a subset check whether you have a marked checkbox in list. 3. check selective access.

阿宝oja

Hey, If I understand your issue correctly, Line items will be editable only for the lowest level of the hierarchy, you can summary of the Override to either "Any" or "All ".

阿宝oja

Hi Akash, You can ask your peers to give you access and change to mode of the model to Standard from Locked, or else drop a mail to anaplan support. Thanks

阿宝oja

Hi Markcol, Can you please show the formula written for the "Forecast Months only" line item.

阿宝oja

Hi Markcol, I will suggest you create SYS module and create a line item to update the formula to show only relevant columns and use that filter in this view. OR you can your show feature in Anaplan UX(but this needs to be updated every year), from the check you can select which times you want. Thanks Pooja

阿宝oja

Hey Muizz, If I understand your scenario correctly, please check the below solution. if it's not as per your expectation please revert back. You can't use Delete from List for Anaplan Native Time list, instead you can simply create 2 line items one is Boolean for selection of month to clear and another "No data" formatted line item to clear data from a selected month like below. Then create a saved view with the “Delete time” line item as a filter and import the “Clear Selected” line item from the saved view to the Churn line item having data. After importing you will see only data from selected months(i,e April and May) got cleared. Thanks

阿宝oja

Hey, Can you provide more details on this? I might have understood your question wrongly, if you want to see employees under department simply you have to select "before" by clicking the group icon in grid view like below. Thanks Pooja

阿宝oja

Hi, I think instead of a page selector you can use a field card in NUX using a line item to select the hierarchy and right a logic saying "item(hierarchy) = Hierarchy Selection Line item". Thanks Pooja

阿宝oja

In EMP007 module update formula in "ROle" line item "SYS001 EMp details.Role", as both target and source are having same EMP list it will map automatically. Then use this Role line item to lookup salary by role like EMP008.Total Salary[Lookup:Role].

阿宝oja

Hey, This happened to me quite a sometimes. All you can try is Switch the browser or try in incognito mode. Clear your browser history and cache. If the issue still persists then contact support@anaplan.com.

阿宝oja

你好,如果我理解正确你的要求。阿宝st, offset, and lag functions will work not sure why you don't want to use them. Other than this, you can create the SYS module dimensioned by Time and create a line item and add the formula " Item(time) -12", which will give the previous year's months, then you can use this line item to lookup to get FY22 headcount value in FY23, like "IF current year Then EMP00 Headcount else EMP00 Headcount[lookup:SYS:PY Months]". Hope this is work, or else please revert back.

阿宝oja

Hi, You can refer to below links: Procedure is to get a training Anaplan ID. You can avail 90 days trial version and using this ID, from below learning anaplan website, you can register to any courses and complete. Register in community.anaplan.com Login to learning.Anaplan.com https://community.anaplan.com/t5/Anaplan-Access-Beta/ct-p/ATBReg Hope this helps, happy planning! Thanks, Pooja G

阿宝oja

Hi, If I understand your requirement correctly, I think below solution will work. Create Line item "Switchover+1" and update formula as "IF ISACTUALVERSION() THEN BLANK ELSE ITEM(Time)" and update summary to FIrst non blank. In CHurn Rate line item update formula as "IF Time Period[SELECT: TIME.'FY22'] + 1 <= ITEM(Time) THEN 0 ELSE Churn / PREVIOUS(Revenue)". By this rate after switchover date will be Zero

阿宝oja

Hi, If I understand your requirement correctly, We can handle it through custom weeks numbered list where you reset it every quarter and map it to Time manually/Hardcode.

阿宝oja

HI, If I understand it correctly, this feature is still on road map in community Idea exhange. Please check below link: https://community.anaplan.com/t5/Idea-Exchange/Group-ungroup-columns-rows-in-New-UX/idi-p/70744 Hope this helps. Thanks Pooja

阿宝oja · ‎01-02-2020

Very good content and handy @kavinkumar.

阿宝oja · ‎08-09-2019

Hi Vikas, You can add extension by using this link: https://chrome.google.com/webstore/detail/a%20-for-anaplan-model-buil/najhicgfojolaebaoccdbopmobcdhpgi?hl=en then enable what you required. Hope this helps. Thanks

阿宝oja · ‎07-25-2019

Hi, I just tried Timesum just to avoid extra line item to be created, it worked as expected(attached screenshot for same).

阿宝oja · ‎07-25-2019

Hello, For this scenario, create separate line time to get Hire Date-1as shown below then use it in Lookup clause.

阿宝oja · ‎03-05-2019

Hi Uma, As a best practise replicate same List into Module. Create Single cell Employee list formatted line item and one Boolean line item. Write a logic shown Below. Now Apply a filter based on Boolean as shown below. Now Publish both Single selection line item and filtered saved view. Thanks Pooja

阿宝oja · ‎03-05-2019

Hi, https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/NAME.html?Highlight=name Thanks

阿宝oja · ‎02-14-2019

Hi Guy, You can try RANK function here (attached screenshot for reference). Hope it works for ur scenario. Thanks Pooja

阿宝oja · ‎02-08-2019

Hi @gregoryTan The partial sums cannot be calculated directly but can be done instead. Here is the work around below. Hope this works for your stated problem. Step1:Create a property called previous year in Year category List as per Screenshot below. Step2: In Calculation module create Contract Summary and Contract Summary 1 line items and put below attached formulae respectively. Step 3: To calculate Change(%) use below formula then you will get desired result. Thanks Pooja