- Community
- :
- About varun.joshi07
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 varun.joshi07
since
12-05-2019
06-13-2021
varun.joshi07
Occasional Contributor
Activity Feed for varun.joshi07
- Posted Re: Need anaplanners on Anaplan Platform. 12-30-2020 01:59 AM
- Posted Re: Year To Date (YTD) summary column not showing data on Anaplan Platform. 12-06-2020 09:58 AM
- Got a Kudo for Re: Year To Date (YTD) summary column not showing data. 12-02-2020 08:36 AM
- Posted Re: Year To Date (YTD) summary column not showing data on Anaplan Platform. 12-02-2020 06:38 AM
- Posted Re: Year To Date (YTD) summary column not showing data on Anaplan Platform. 12-02-2020 06:33 AM
- Posted Year To Date (YTD) summary column not showing data on Anaplan Platform. 12-01-2020 09:51 AM
- Posted Re: Behavior of Time Setting in future fiscal years. on Anaplan Platform. 12-01-2020 09:48 AM
- Posted Behavior of Time Setting in future fiscal years. on Anaplan Platform. 12-01-2020 03:40 AM
- Posted Re: Data in 2 modules with exactly same lists on Anaplan Platform. 11-20-2020 02:27 AM
- Posted Data in 2 modules with exactly same lists on Anaplan Platform. 11-18-2020 04:07 AM
- Got a Kudo for Re: Formula to hard code list item. 11-17-2020 12:36 PM
- Posted Re: Formula to hard code list item on Anaplan Platform. 11-17-2020 12:29 PM
- Posted Formula to hard code list item on Anaplan Platform. 11-16-2020 12:10 PM
- Posted Re: Display Fiscal Year Total on Anaplan Platform. 11-16-2020 04:58 AM
- Posted Display Fiscal Year Total on Anaplan Platform. 11-15-2020 01:37 PM
- Posted Re: Data Import From Module 1 to Module 2 on Anaplan Platform. 11-15-2020 07:10 AM
- Posted Re: Data Import From Module 1 to Module 2 on Anaplan Platform. 11-14-2020 11:16 AM
- Posted Data Import From Module 1 to Module 2 on Anaplan Platform. 11-13-2020 01:09 PM
- Posted Re: Copy data from Actual Version to Budget Version on Anaplan Platform. 11-12-2020 05:40 AM
- Posted Copy data from Actual Version to Budget Version on Anaplan Platform. 11-10-2020 01:05 PM
21
Posts
2
Kudos
0
Solutions
12-30-2020
01:59 AM
@zulychg Hi Zuly, I have mailed you for this opportunity. Thanks, Varun
... View more
12-06-2020
09:58 AM
I have another query related to YTD calculation. If YTD is calculated based on current period set under model calendar, then what would I need to do when business wants to see YTD calculation from Jan to Dec. For instance, I have set current period as Jan 20, If user enters $10 in Jan 20, the YTD value should be $10. If user enters $15 in Feb 20, then YTD value should show $25. If user enters $10 in Mar 20, then YTD value should show $35. Above example user case, I am not able configure. Need expert advice for this user case. Thanks, Varun
... View more
12-02-2020
06:38 AM
1 Kudo
@Rashmih I got the resolution. I was doing mistake. The issue was that I was using Time Range FY 18 YTD, whereas Current Period in model calendar is set to FY20. When I created Time Range FY 20 YTD, which was aligned to Model Calendar setting, where Current Period is set to Jan 20. It worked. Thanks Rashmi for giving idea, which in turn, helped me find the solution. Thanks, Varun
... View more
12-02-2020
06:33 AM
@Rashmih Thanks for reply. Yes, I do have current period enabled, but YTD value is displaying.
... View more
12-01-2020
09:51 AM
Hi Experts, I created one module, in which I added Time Range i.e FY 18, Number of Periods = 1, and Aggregation as Year To Date. For testing purpose, I added some data in some periods. I can see total amount under FY18 (Summary column), but no data appearing under YTD column. Please let me know, if I have missed anything. Thanks, Varun
... View more
Labels:
- Labels:
-
Calculation Functions
-
Dashboards
-
Modeling
12-01-2020
09:48 AM
@akhil.kohli Thanks Akhil There is an example, I would like to share. Lets suppose, Current Fiscal Year is 2021. I have created a Model Calendar for current fiscal year FY20. I have created a module and shared the UX with business users to enter data. Business enters data in the mid of every year as part of their budgeting process, which is year activity. 2020 Budgeting Activities are completed. Next budgeting activity will start in Year 2021. Let's say, year 2021 has come, budget cycle is going to start shortly, in this case, would I need to change the current fiscal year to FY21 in Model Calendar? Thanks, Varun
... View more
12-01-2020
03:40 AM
Hi Experts, I have a question about Time Setting in anaplan. Under Model Calendar, there is an option "Current Fiscal Year". At the moment, I can see FY20 as current fiscal year and can see past 5 fiscal years (FY15 - FY19) and future 5 fiscal years FY21 - FY25. As time setting is in-built functionality. Does FY15 disappear when FY21 is selected going to next year. How dynamically current fiscal year work, in case of future years keep becoming current year. Do I need to select FY21 manually as current fiscal year, once fiscal year 2021 starts. Would data stored against FY20 will delete, what would happen to FY21 data entered in FY20. Please let me know, if my queries are not clear. Here I am thinking about futuristic perspective, when current fiscal year becomes past year, future fiscal year keeps on becoming current fiscal year. I want to understand how time setting works in such cases. Thanks, Varun
... View more
Labels:
- Labels:
-
Modeling
11-20-2020
02:27 AM
Thank you Jitendra for reply. Got the point.
... View more
11-18-2020
04:07 AM
Hi Experts, I have a doubt. I have created a module i.e. Module 1 and also created another module i.e. Module 2 with exactly same lists as Module 1. In Module 1, have entered so many data, but that data is not appearing in Module 2, which is same as Module 1. Is it the expected behavior? where we have 2 exactly same module, in one module has data in that, where as another module does not show data. Thanks, Varun
... View more
Labels:
11-17-2020
12:29 PM
1 Kudo
Thanks Rob for reply. The formula worked. I am trying to figure all possible options to bring data in module 2 from module 1, hence used action to import data.
... View more
11-16-2020
12:10 PM
Hi Experts, I have two modules. Module 1 has got lists: Cost Center, Cost Element, and Time. Module 2 has got lists, Cost Center, Cost Element, Time, and Profit Center. I need to bring data from module 1 to module 2. Whatever data will be coming into module 2, will be stored against P9999 profit center. Rest other list items will be derived as it is in module 1. I have below option to achieve the above requirement. I can import data from Module 1 to Module 2 and use Fixed Item for Profit Center in Mapping and load But instead of using this option, I want to check that Like LOOKUP formula which refers mapping to derive additional list item through system module mapping. Is there any funtion, which I use to hardcode P9999 profit center in target module using that in formula. Thanks, Varun
... View more
Labels:
- Labels:
-
Calculation Functions
-
Modeling
11-15-2020
01:37 PM
Hi Experts, I have created a module, whose default view consists "All Periods & FY19, All Periods & F20, and All Periods & FY21". From this default view, I created a Saved View only comprising all periods of FY20 and all periods of FY21. To achieve, this I used filter based on the system module, created on Time Setting. Filter is Forecast Period Only (START() >= CURRENTPERIODSTART()). The issue, I am facing is, in Saved View, I can see all periods Jan to Dec for FY20 and Jan to Dec FY21, but I am not able to display fiscal year total i.e. FY20 and FY21. On the other hand, in default view, fiscal year total is appearing together with periods. Please let me know, if I have missed something in configuration. Thanks, Varun
... View more
Labels:
- Labels:
-
Modeling
11-15-2020
07:10 AM
Thanks so much Akhtar for helping me solve my requirement. It worked.
... View more
11-14-2020
11:16 AM
Thanks Akhtar so much for reply, Let me try this solutions, I will get back to you and let you know, if I get successful.
... View more
11-13-2020
01:09 PM
Hi Experts, I have a question. I have a module, lets say, Module 1, in which I have included 2 lists, Time and Version. Through this module, user enters data. I have another module, let's say, Module 2, where I have same 2 lists and time, but I do not have version in the second module. I want to copy data from the Module 1 to Module 2. Any suggestion, how I can achieve that. Module 1: Cost Center list, Cost Element list, Time, and Version Module 2: Cost Center list, Cost Element list and Time. Difference between both modules is Version list. Want to copy data from Module 1 to Module 2. Thanks, Varun
... View more
Labels:
11-12-2020
05:40 AM
@nathan_rudman @rob_marshall Thanks for stepping forward and help me answering my query. The reason for not using Bulk Copy is because it will copy all periods and all years data, but here I have custom requirement, where I just want to copy Actual Year 2019 to Forecast Year 2020 and 2021. After trying many times, I found a way to achieve this requirement. Thanks, Varun
... View more
11-10-2020
01:05 PM
Hi Experts, I am testing a scenario, where user wants to update forecast data. But before user does it, he wants to copy previous year actual data to current year and next year forecast version. I do not want to use "Bulk Copy" functionality. Scenario Copy data from Actual version and Year 2019 to Forecast Version & Year 2020 & Year 2021, Actual, Year 2029 ---> Forecast, 2020, 2021 I created a module 1 with Version, Time, Cost Center, Cost Element, Line item: Amount. Store dummy actual data for year 2019. Created another module 2 with same lists and selected forecast version and used formula "POST" from module 1, I am able to copy data from previous year to next 2 year, but I can not see Actual data in Forecast version. Please guide. Thanks, Varun
... View more
Labels:
- Labels:
-
Calculation Functions
-
Modeling
11-10-2020
08:41 AM
Hi Experts, I have been trying to test some scenarios in Anaplan. One scenario is I have to pick Actuals from Last Year for all periods and copy them to all periods to Current Year and Next Year For instance Current Year is 2020 Last Year is 2019 Next Year is 2021 Data of all periods from 2019 must be copied to all periods of 2020 and 2021. What I have done is, I have been able to copy data from all periods of last year 2019 to all periods to 2020, but not able to figure out to copy to all periods of year 2021. Please let me know, if anyone has faced this scenario. Thanks, Varun
... View more
Labels:
11-09-2020
11:12 AM
Thank You Aaron. I am from India working as Lead Consultant in SAP Business Planning & Consolidation for 9 years. I came to know about Anaplan when my current client chose to stop BPC and move on Anaplan Tool. Since then, I got very curious to know more about this tool. I am doing my best to learn Anaplan Modelling as much as I can. Also I would like share my view that Anaplan is really a very nice Planning & Budgeting tool and How am I telling so confidently, because as I mentioned, I have been working on SAP Planning tool i.e. BPC for 9 years. I could easily compare when I completed Level 1 and Level 2 Anaplan Model Building Certification. I hope that I will get an opportunity, one day, to work on an Anaplan implementation for a client Thanks, Varun
... View more
My kudoed posts
| Subject | Kudos | Posted |
|---|---|---|
| 1 | 12-02-2020 06:38 AM | |
| 1 | 11-17-2020 12:29 PM |
My Top Kudoed Posts
| Subject | Kudos | Views |
|---|---|---|
| 1 | 1523 | |
| 1 | 1116 |
My kudoed posts
| Subject | Kudos | Posted |
|---|---|---|
| 1 | 12-02-2020 06:38 AM | |
| 1 | 11-17-2020 12:29 PM |
