- Community
- :
- About vardhan_24
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 vardhan_24
since
04-26-2018
03-11-2019
vardhan_24
Occasional Contributor
7
Posts
1
Kudos
0
Solutions
03-10-2019
10:46 PM
Thanks Vignesh for the detailed reply !
... View more
03-08-2019
02:35 AM
Hi All I have an audit module which has a list as dimension. The list contains multiple report names. The List is pivoted as rows and line items has 2 columns as Count and Total_amount. My need is to go to respective source module of the reports and fetch the total count of records in that report and sum(Total_amount) in that report. Please help suggest a right approach for the same. Thanks Yash
... View more
Labels:
03-07-2019
02:34 AM
1 Kudo
Hi You can use the hierarchical capability of SELECT() function to roll up any hierarchical attribute and get the desired value. In this case, you can roll up the total items sold at the top level.
... View more
03-07-2019
02:29 AM
Hi It's always good to store your transactional data in data hub (separate model) and then use action for imports. As a best practice one should always create a list for unique identifiers and then use that list as a dimension in the module. Thanks Yash
... View more
03-07-2019
02:06 AM
Hi Uma You can try using MOVINGSUM(). It should solve your issue. Thanks Yash
... View more
03-07-2019
01:54 AM
Hi Prabakaran You may use the ITEM() function to firstly extract the member of the list and then subsequently use NAME() to get the text value. Thanks Yash
... View more
Activity Feed for vardhan_24
- Got a Kudo for Re: Get Value of Top Level. 10-25-2019 11:25 AM
- Posted Re: Fetching Count and Sum Information different Reports on Anaplan Platform Discussions. 03-10-2019 10:46 PM
- Posted Fetching Count and Sum Information different Reports on Anaplan Platform Discussions. 03-08-2019 02:35 AM
- Posted Re: Get Value of Top Level on Anaplan Platform Discussions. 03-07-2019 02:34 AM
- Posted Re: Import raw data of transaction on Anaplan Platform Discussions. 03-07-2019 02:29 AM
- Posted Re: Calculations on Anaplan Platform Discussions. 03-07-2019 02:06 AM
- Posted Re: Data format change from List to Text on Anaplan Platform Discussions. 03-07-2019 01:54 AM
My Top Kudoed Posts
| Subject | Kudos | Views |
|---|---|---|
| 1 | 857 |
My kudoed posts
| Subject | Kudos | Posted |
|---|---|---|
| 1 | 03-07-2019 02:34 AM |
My kudoed posts
| Subject | Kudos | Posted |
|---|---|---|
| 1 | 03-07-2019 02:34 AM |