- Community
- :
- About iWonder
Ask the Community
-
Ask a QuestionGet answers to platform specific questions from Anaplanners everywhere.
-
Suggest an IdeaShare ideas for platform improvements, training, the Community, and more.
-
Get Training HelpComplete your training with support from the experts.
-
Contribute ContentWorkshop content, submit for approval, and contribute best practices to the Community.
-
Connect with CommunityShare feedback, ask questions, and get support from the Community.
About iWonder
since
10-14-2019
12-04-2020
iWonder
New Contributor
Activity Feed for iWonder
- Posted Re: Property in List using a formula on Anaplan Platform. 02-12-2020 04:58 AM
- Posted Re: Property in List using a formula on Anaplan Platform. 02-12-2020 04:56 AM
- Posted Re: Property in List using a formula on Anaplan Platform. 02-12-2020 04:56 AM
- Posted Re: Property in List using a formula on Anaplan Platform. 02-12-2020 04:55 AM
- Posted Property in List using a formula on Anaplan Platform. 02-10-2020 09:35 AM
- Posted Re: Delete from list all levels on Anaplan Platform. 01-20-2020 10:17 AM
- Posted Re: Delete from list all levels on Anaplan Platform. 01-20-2020 06:23 AM
- Posted Delete from list all levels on Anaplan Platform. 01-20-2020 06:01 AM
- Posted Re: Import data to a module, best practice? on Anaplan Platform. 01-13-2020 07:48 AM
- Posted Re: Import data to a module, best practice? on Anaplan Platform. 01-13-2020 07:47 AM
- Posted Re: Import data to a module, best practice? on Anaplan Platform. 01-13-2020 07:45 AM
- Posted Re: Import data to a module, best practice? on Anaplan Platform. 01-13-2020 06:14 AM
- Posted Import data to a module, best practice? on Anaplan Platform. 01-13-2020 05:51 AM
13
Posts
0
Kudos
0
Solutions
02-10-2020
09:35 AM
I have a unique key list which is a standard naming convention of 12345_123456_123456. I would like to use a formula to identify the last 6 digits that are not 000000 or 0000002 and create a list subset of those. Can you help me figure out the formula for that? Thanks!!
... View more
Labels:
01-20-2020
06:01 AM
Hi all, I have 4 levels of accounts, I want to delete accounts not used in my modules. I have created a module to identify accounts not used and set a boolean format. I created an action for Delete from Selection that references the module boolean line. It only seems to delete the base list level. How do I adjust so it deletes all parent items if all children are deleted?
... View more
Labels:
01-13-2020
07:48 AM
Thank you, yes the smart-keys are 26 characters each. I am trying Misbah's approach 🙂
... View more
01-13-2020
07:45 AM
I created a unique key with combination of account_cost center_cost pool. I imported those into a flat list. I created module with 2 List Items -> Unique Key (for text format) and Amount. This imported successfully with dimensions of version, and month/year time scale. Next I will parse the account_cost center_cost pool in the module using calculation functions. Is this the best approach or should the Unique key not be made into a list at all?
... View more
01-13-2020
05:51 AM
Hello, I have the following data: Name/Formula/Format/Notes Transaction # /CODE(ITEM(# Transactions))/Text/(# Transactions is the numbered list I created with Properties of Account (Text Format), Cost Center (Text Format), Cost Pool (Text Format), Amount (Number Format), Version (Text Format), Period Text Format) Cost Center/No Formula/Text/ (I have a hierarchy set up for this) Account Code/No Formula/Text/ (I have a hierarchy set up for this) Cost Pool/No Formula/Text/ (I have a hierarchy set up for this) Year and Month/No Formula/Text/ (2 years by month) Scenario/No Formula/Text/ (i.e. Budget/Actuals) Amount/No Formula/Number Amount I have managed to import to a module via a numbered list by first importing the same data into a numbered list then using the numbered list as dimension and the other fields as line items. I am not sure this is the best approach as I will need to aggregate the data for calculations etc. Any advice on best practice? The data won't import using the other dimensions as there are multiple instances of cost center/accounts/in the data. Much appreciated for any advice you can provide.
... View more
Labels: