- Community
- :
- About lilasququ
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 lilasququ
since
03-21-2019
Friday
lilasququ
Contributor
Activity Feed for lilasququ
- Kudoed Re: How to identify zeroes uploaded by users vs never uploaded for rob_marshall. Thursday
- Posted Re: How to identify zeroes uploaded by users vs never uploaded on Anaplan Platform. Thursday
- Posted How to identify zeroes uploaded by users vs never uploaded on Anaplan Platform. Wednesday
- Got a Kudo for Re: Multiple import steps in a Process - merge file selection?. 08-26-2021 12:09 AM
- Posted Re: Synchronizing members on two grids on Anaplan Platform. 08-25-2021 05:13 PM
- Posted Re: Synchronizing members on two grids on Anaplan Platform. 08-25-2021 05:06 PM
- Posted Re: Synchronizing members on two grids on Anaplan Platform. 08-25-2021 04:37 PM
- Posted Synchronizing members on two grids on Anaplan Platform. 08-25-2021 04:24 PM
- Got a Kudo for Re: Multiple import steps in a Process - merge file selection?. 08-25-2021 04:17 PM
- Posted Re: Multiple import steps in a Process - merge file selection? on Anaplan Platform. 08-25-2021 04:15 PM
- Posted Multiple import steps in a Process - merge file selection? on Anaplan Platform. 08-25-2021 03:07 PM
- Posted Re: Add comment field to a Time dimensioned module on Anaplan Platform. 08-18-2021 01:44 PM
- Posted Re: Add comment field to a Time dimensioned module on Anaplan Platform. 08-18-2021 01:43 PM
- Posted Re: Add comment field to a Time dimensioned module on Anaplan Platform. 08-18-2021 01:08 PM
- Posted Re: Add comment field to a Time dimensioned module on Anaplan Platform. 08-18-2021 11:55 AM
- Posted Re: Add comment field to a Time dimensioned module on Anaplan Platform. 08-18-2021 11:54 AM
- Posted Add comment field to a Time dimensioned module on Anaplan Platform. 08-18-2021 11:46 AM
- Posted Re: Report design question on Anaplan Platform. 08-17-2021 06:54 PM
- Posted Re: what formula to use to get info from a module lineitem to a list property on Anaplan Platform. 08-17-2021 03:55 PM
- Posted Re: what formula to use to get info from a module lineitem to a list property on Anaplan Platform. 08-17-2021 03:44 PM
38
Posts
6
Kudos
1
Solution
Wednesday
I searched for the posts regarding zeroes vs null values but don't think I found an answer to my question. So in module A, when people create projects they input values. These values are brought to module C as reporting values. In module B, people have the ability to upload values from Excel. The formula in module C says , if values uploaded from module B is zero, use the values from module A, otherwise use the uploaded values from module B. So here I don't know how I can create a formula that recognize whether it's a zero from module B (truly uploaded from Excel) or it's null (people never uploaded value from Excel to this project). Any help is appreciated. Thank you.
... View more
Labels:
08-25-2021
05:13 PM
No it doesn't. Will it be because the card on the left is a fixed module view? But I"m only trying to populate the selection for the one on the right.
... View more
08-25-2021
05:06 PM
I can't make it work. It seems it only creates a page selector on the page but does not sync with the grid on the left?
... View more
08-25-2021
04:37 PM
on the top meaning on the page selector? I tried but it didn't work out. What did I miss here...
... View more
08-25-2021
04:24 PM
I have two cards (see attached screen shot) on the new UX dashboard. (different dimensions for the 2 modules so they couldn't be combined to 1 grid) My goal is that, when I select the project (row) on the left grid, only the project that I select will show up on the right grid. So the project members synchronize. I think used to do similar things on classic dashboard but not sure how to achieve it here... Thanks!
... View more
Labels:
08-25-2021
04:15 PM
6 Kudos
I got it. The file names in the source label have to the same. I'm adding a new import action and the file name is different, even though I can use the same file for all imports. I just renamed the file and created a new import action. It works now.
... View more
08-25-2021
03:07 PM
Using the same csv file, I want to be able to import to different modules and it will be seamingless to the users. But the "Choose File" button appears twice when I click on the button even though it's the same file I'm importing. Is there a way to show it only once? Thank you.
... View more
Labels:
08-18-2021
01:44 PM
So even if people update data within Anaplan, would there be a good way to present the Comment field on the grid?
... View more
08-18-2021
01:43 PM
Do you mean to update the data directly on the web? Because there are too many projects to update....People just like using Excel...
... View more
08-18-2021
01:08 PM
These project codes are truly codes. I guess you meant creating an additional import action to include in this process and it will be seamingless to the users? They actually export this file first, update numbers and import it back. Then they will have to add the comments by themselves I assume?
... View more
08-18-2021
11:55 AM
Strange I did upload as picture. I've just posted it in the reply. Thanks.
... View more
08-18-2021
11:46 AM
We have a process that users import data via Excel to Anaplan. The file format is shown as attached. The business would like to add a comment field at the end of the column for each project (see screenshot. the comment field is just a mock-up on Excel and does not exist in Anaplan yet). To add a comment field in this time dimensioned module and nicely present it on the export, any recommendation? Thank you!
... View more
Labels:
08-17-2021
03:55 PM
Ooops that was the first thing I tried but I missed an ' Thanks for confirming and it works now.
... View more
08-17-2021
03:44 PM
I try to export the property in the Label. So it appears once in the row header. If it's a line item in a module with time dimension, it gets exported within every time period.
... View more
08-17-2021
03:01 PM
So I have a module which is only listed by Project. This module is presented in a form to the users to collect a lot of the information. One of the lineitem in this module is Project Status. Now I create Project Status as a property on the Project list. Which formula shall I use to grab the project status from the module to the list property?
... View more
Labels:
08-17-2021
02:32 PM
Thank you. So in order for the export to happen it seems I will need to create a button on the UX page. Users only have access to the dashboard. Is there not a solution to include that on the grid or in the export from the grid?
... View more
08-17-2021
10:38 AM
Alongside? do you mean in a different card? Users want to export the one grid as a report so it cannot be separated. Is there a way to them combined?
... View more
08-16-2021
07:22 PM
In the attached screen shot you will see one of our report by Project and by Time. This module is dimensioned by Time, Project List, Function list and Funding type. We have data for actual, forecast and etc. We need to see Project ID and Project Status information on this report. But if I add them as line item, they show up under every month. I tried hard coding the module view but people can select the month or year on the report. Project ID is a property in the Project list. So I'm not sure if there's a good way to display that in this situation? Any insight would be helpful. Thanks.
... View more
Labels:
08-16-2021
03:49 PM
What would be the considerations when we try to decide whether we use Version or a List for the scenarios, such as Actual, Budget and Forecast. For forecast, we will have a monthly version: Jan_FCST, Feb_FCST and etc. And we need to be able to store the prior forecast data and run variance analysis. So would using a list be more beneficial?
... View more
Labels:
05-07-2020
11:10 AM
I'm now a tenant admin. I'm still seeing the same thing as a workspace admin. Only the first page appear or I can sort to see a different 1st page. But I don't have the option to export. How can we achieve that then? We need to have user login history for the 300 users. Thanks!
... View more
05-06-2020
10:42 AM
Thanks. I can see the user login history but only one page? But I can't export the list. I will ask the tenant admin then. Thanks.
... View more
05-06-2020
10:22 AM
How do we export the user list with the login history? What kind of access is needed? I'm workspace admin and don't seem to have access?
... View more
Labels:
05-05-2020
04:21 PM
It's a little hard to talk through here. But I did get inspiration to find a workaround for now. I'm cherry picking the customers I need to get the total for now.
... View more
05-04-2020
12:38 PM
The module is by Semi-conductor Customer for example. The line item sales needs to be shown by customer: So the formula references another master module to pull data by customer using a Sum function. The formula is something like: 'Mater Module'.Sales[Sum:ProductCustomer.Semi-conductor Customer']. "ProductCustomer" is a List used in the Master Module. "Semi-conductor Customer" is a property in that list. Now I'm creating a new line item total Sales of semi-conductor customer. It should just grab the top of the list from this module. But when I just reference the Sales, it is always equal to it for every customer.
... View more
05-01-2020
04:27 PM
Not working in my case because the line item that I'm trying to grab, is a Sum function that looks up the customer.
... View more
05-01-2020
03:58 PM
I have a subset A which is a selection of the Global Customer List. In my module which applies to the subset A, I'm trying to retrieve the Sales for the top level of the subset "total customers" (only the total of the selection of the customers from the global customer list). I tried [Select:'Subset A'.'total customers']. It is invalid. I then changed it to [Select:'Global Customer'.'total customers'], it works. Unfortunately this is not the total customers number that I need. It seems the Select function does not work with a subset? What would be the proper function to use then? Thank you!
... View more
Labels:
My Accepted Solutions
| Subject | Views | Posted |
|---|---|---|
| 1014 | 07-17-2019 02:15 PM |
My kudoed posts
| Subject | Kudos | Posted |
|---|---|---|
| 6 | 08-25-2021 04:15 PM |
My Top Kudoed Posts
| Subject | Kudos | Views |
|---|---|---|
| 6 | 475 |
My kudoed posts
| Subject | Kudos | Posted |
|---|---|---|
| 6 | 08-25-2021 04:15 PM |
Posts I kudoed
| Subject | Kudos | Author | Latest Post |
|---|---|---|---|
| 1 |