- Community
- :
- About CommunityMember132037
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 review, and contribute to the Community.
-
Connect with CommunityShare feedback, ask questions, and get support from the Community.
About CommunityMember132037
since
12-03-2019
yesterday
CommunityMember
Contributor
Activity Feed for CommunityMember132037
- Kudoed "Average" is close to useless. Need to be able to automatically only average non-zeros for tscott. a week ago
- Kudoed Ability to exclude zero values from AVERAGE calculation for karl.mcphee. 2 weeks ago
- Posted Re: Average for a Period of Time for Next Period on Anaplan Platform. 2 weeks ago
- Kudoed Re: Average for a Period of Time for Next Period for Badam. 2 weeks ago
- Posted Average for a Period of Time for Next Period on Anaplan Platform. 2 weeks ago
- Kudoed New UX - Landing page for NUX Apps for AndreyPol. 05-25-2022 10:54 AM
- Kudoed NUX Open Home Page after opening an app for filip.sypniewski. 05-25-2022 10:50 AM
- Kudoed Landing Dashboard on New UX for gdewan. 05-25-2022 10:49 AM
- Posted Re: NEXT or Previous cell values without Time dimension on Anaplan Platform. 05-24-2022 03:03 PM
- Kudoed Re: NEXT or Previous cell values without Time dimension for rob_marshall. 05-24-2022 03:02 PM
- Posted Re: NEXT or Previous cell values without Time dimension on Anaplan Platform. 05-24-2022 12:20 PM
- Kudoed Re: NEXT or Previous cell values without Time dimension for AWhitworth. 05-24-2022 12:17 PM
- Kudoed Re: NEXT or Previous cell values without Time dimension for PavanKumar. 05-24-2022 12:17 PM
- Kudoed PREVIOUSITEM() formula which is like PREVIOUS() but references a list item instead of time for usman.zia. 05-24-2022 12:17 PM
- Kudoed Re: How to convert text to date for Misbah. 04-21-2022 03:59 PM
- Kudoed Re: Creating a Module Report but need to bring detail for alexpavel. 03-22-2022 10:31 AM
- Posted Re: Creating a Module Report but need to bring detail on Anaplan Platform. 03-14-2022 11:59 AM
- Kudoed Re: Creating a Module Report but need to bring detail for TimothyThomas. 03-14-2022 11:55 AM
- Posted Re: Creating a Module Report but need to bring detail on Anaplan Platform. 03-11-2022 11:43 AM
- Kudoed Re: Cumulative SUM for Top Ten Items for ChrisAHeathcote. 03-10-2022 12:56 PM
14
Posts
1
Kudos
0
Solutions
2 weeks ago
Thank you @Badam !! Your solution work but with a slightly change on the periods MOVINGSUM(Actual Load, -6, -3, AVERAGE). That's the formula for Q1 FY24 but then I want to make Q2 FY24 to Q4 FY24 equals to Q1 FY24 because if not the formula for the other periods will take the zeros of the FY23 quarters that had not happened yet. So on the example below - I will need that Q2 FY24 ---> have as value $10,258. Thanks! Yordana T.
... View more
2 weeks ago
Hi Team, I am trying to calculate the "Average" for a Expense for the Period of "FY24". And I want to calculate using the Average from Q3 FY22 to Q2 FY23. On the "actual line items are the expenses for prior quarters and on "RunRate Line Item" I want to calculate the Average for those 4 prior quarters. I am try TIME SUM and it didn't work unless I am missing something =( Would you please help me find a solution? Thanks! Yordana!
... View more
Labels:
- Labels:
-
Calculation Functions
-
Modeling
05-24-2022
03:03 PM
Perfect - Will try it out! Thank you! 😊
... View more
05-24-2022
12:20 PM
Hi @rob_marshall Can you share an screenshot on how this will be done as a SYS Module? I am trying to achieve the same. Thanks!
... View more
03-14-2022
11:59 AM
Hi @TimothyThomas I will give it a try and let you know how it goes! 😃 Thanks for the help on this! Regards,
... View more
03-11-2022
11:43 AM
Hi Timothy, Thanks for taking the time to look at it 😃 Actually what I want to show if the "Report Name" Line Item that is on DATA00 Module. Because one Vendor in a specific period of time can have multiple "Report Name", meaning that have multiple transactions. It could be that we bought it because of Event 1and that same period we bought it because of Event 2, so the "Event 1 and Event 2" are the Report names under the same vendor. Hope it makes sense. So I need to find a why to linked I guess the REPORT 002 Module with the DATA00 Module, or create another module to bring those details? Thanks for the "SUM & LOOKUP" - It is on my checklist to change it, but I was first trying to build the high level report.
... View more
03-10-2022
12:52 PM
Hi Team, I hope you can help me with a step I am struggling with. I have Module that have 4 years "Raw Data - Module: Data 00 - All T&E" for Transaction detail (using an Index as a list) and it has many items such as Vendor, Periods, BU, Functions, Account #. And as I need it for reporting purposes, I have bring the Lists with FINDTITEM or Parents, so it can be SUM. Then as I need the Expense by Vendor, Function, Account and Business - I have created a Second Module and use SUM to bring the values. Finally - We are creating a Dashboard with this information, where you can see your Total Expense by BU, Function and Account using the REP02 - Module. Then if you click in the Function, then it will bring you the list of vendors (all this works fine). However, we want to be able also to bring the "Report Name" of that vendor which is store on the "Raw Data MOdule - DATA 00 - All T&E". One vendor can have multiple "Report name" because it is the description of the Transaction - The idea is to be able to click the "Vendor Name" from REP02 Module (once in the dashboard) and synchronized to bring the "Report Names" and the "Expense Associated" Hope you can help me and point me in the right direction. Thanks!
... View more
Labels:
- Labels:
-
Calculation Functions
-
Dashboards
-
Modeling
08-25-2021
10:55 AM
Thank you @ChrisAHeathcote !! It worked perfectly - I had no clue on how to use the IF THEN ELSE as I though that I needed to apply first SUM and then the formula with the RANCUMULATE (a little bit of misunderstanding on my end) . I have just modify a little bit the formula =IF RANKCUMULATE(Vendor %, Rank, ASCENDING)>0.8 THEN 0 ELSE RANKCUMULATE(Vendor %, Rank, ASCENDING, TRUE, Group By) as it was given me 0% for the subgroups, so I added =IF RANKCUMULATE(Vendor %, Rank, ASCENDING, TRUE, Group By)>0.8 THEN 0 ELSE RANKCUMULATE(Vendor %, Rank, ASCENDING, TRUE, Group By) and "Magic Happen". Thanks! 😃
... View more
08-24-2021
04:11 PM
Hi @ChrisAHeathcote I went an apply a guidance from "Dynamic Ranking" Article and it helped me to "RANK" the vendor at the lowest Level for Product and Cost Center =). But now I don't know what to do on just having the RANKCUMULATE to SUM up to 80% of the Total Expenses. Thanks for the help. A view of the "Blue Print" so far. Regards,
... View more
08-23-2021
06:37 PM
Hi Chris @ChrisAHeathcote Thanks for the help. I did the RANK and it worked 😃 but it seems that is just doing it at a higher level....below on the Picture If I select Corporate as a Concenter then the RANK start at 8 but I think it is because when you put "All Cost Centers - Expenses" like the second picture you have RANK since 1 and so on...so it is being applied at a higher level.....Is that right? Besides I am having issues with the "RANKCUMULATE", I was thinking that should be as follow RANCUMULATE("Vendor%", Expense, DESCENDING, ......) I am having issues with the threshold to stop the calcs up to 70%. Should I add one more line item to do the IF THEN ELSE Formula? Thanks for the help!
... View more
08-23-2021
03:14 PM
Hi There, I was wondering if you can point me in the right direction on finding how to do the below 😃 I am trying to build a report that can show me just the Vendor that make the 70% of the Total Expense. I have 3 dimensions (VEndor LIST, Cost Center and Product). As a Line items I have the "Expense" and "% of Expense". From this data I want to show on a Dashboard just the Vendors that make the 70% of the expense, I have tried cumulative but it doesn't work or maybe I just did it wrong.....Thank you!
... View more
Labels:
- Labels:
-
Calculation Functions
-
Modeling
09-16-2020
11:48 AM
1 Kudo
Hi, I was not able to join but I have question about Formatting - Would there be a way (in the future) to format line items on a Dashboard Report (Not the cells). For Example: be able to Align the line items to the right and some to the left, for a better and understanding view? Be able to highlighted a whole row (line item) when creating the Dashboard Be able to BOLD the whole row as well Regards,
... View more
04-23-2020
03:14 PM
Hi, I am trying to do the same but not as "Column" but as "Row" so my YoY% is a line item. And I am not getting the number I should 😞 If I "Rest" then I have amount I need but if I want to divide it to get the YoY growth then the value doesn't make any sense. Any help would be great! 😃
... View more
04-17-2020
04:00 PM
Agree, this would be very useful when building PnLs as well. So you can easily identify the main line items of the PnLs instead of having all lines items looking just the same.
... View more
My kudoed posts
| Subject | Kudos | Posted |
|---|---|---|
| 1 | 09-16-2020 11:48 AM |
My Top Kudoed Posts
| Subject | Kudos | Views |
|---|---|---|
| 1 | 794 |
My kudoed posts
| Subject | Kudos | Posted |
|---|---|---|
| 1 | 09-16-2020 11:48 AM |
Posts I kudoed
| Subject | Kudos | Author | Latest Post |
|---|---|---|---|
| 13 | |||
| 78 | |||
| 2 | |||
| 95 | |||
| 112 |