About iWonder

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

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

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