About Sorna Raja Prabhu

Sorna Raja Prabhu

Hi @Jsdeloria21, Try this if my approach works. I am using select statement here because i am not 100% clear on your complete requirement and moreover you want to write a different logic for PARKING, that's why Let me know if this addresses your problem Thanks,

Sorna Raja Prabhu

Hi @Jsdeloria21, Can you clarify my doubts so that i will analyse your problem well. 1. i assume Flr Area, units, SP(VAT -ex) are line items and Unit Mix is a dimension of a module. 2. Total/Average (Flr Area) = (Flr Area (Studio)*Unit(Studio)) + (Flr Area (1 BR) *Unit (1BR))+ (Flr Area(2BR)*Unit(2BR)) + (Flr Area (3BR))*Unit(3BR)) + Flr Area(4BR) * Unit *4BR)) /Unit(Total/Average is it a formula written on Flr Area line item...? 3. Total/Average (SP(VAT -ex))=(SP VAT-ex (Studio)*Unit(Studio)) + (SP VAT-ex (1 BR) *Unit (1BR))+ (SP VAT-ex(2BR)*Unit(2BR)) + (SP VAT-ex (3BR))*Unit(3BR)) + SP VAT-ex (4BR) * Unit *4BR)) /Unit(Total/Average is it a formula written on SP(VAT -ex) line item...? 4. I tried to use Flr Area[select:Studio]*Units[select:Studio] and I got the Circular reference in which module are you writing this formula..? and what is the line item name...? Thanks,

Sorna Raja Prabhu

Hi @Jsdeloria21, Can you clarify my doubts so that i will do analyse well. 1. i assume Flr Area, units, SP(VAT -ex) are line items and Unit Mix is a dimension of a module. 2. Total/Average (Flr Area) = (Flr Area (Studio)*Unit(Studio)) + (Flr Area (1 BR) *Unit (1BR))+ (Flr Area(2BR)*Unit(2BR)) + (Flr Area (3BR))*Unit(3BR)) + Flr Area(4BR) * Unit *4BR)) /Unit(Total/Average is it a formula written on Flr Area line item...? 3. Total/Average (SP(VAT -ex))=(SP VAT-ex (Studio)*Unit(Studio)) + (SP VAT-ex (1 BR) *Unit (1BR))+ (SP VAT-ex(2BR)*Unit(2BR)) + (SP VAT-ex (3BR))*Unit(3BR)) + SP VAT-ex (4BR) * Unit *4BR)) /Unit(Total/Average is it a formula written on SP(VAT -ex) line item...? 4. I tried to use Flr Area[select:Studio]*Units[select:Studio] and I got the Circular reference in which module are you writing this formula..? and what is the line item name...? Thanks,

Sorna Raja Prabhu

Hi @kunal_311 - 1. Default means, when you create a new line item, it automatically sets to NUMBER format. so do not change that. 2. Thanks,

Sorna Raja Prabhu

Hi Kunal, The reason is Code and department has formula written that's why.

Sorna Raja Prabhu

Yes Kunal

Sorna Raja Prabhu

Hi @kunal_311 I completely agree with @filip.sypniewski . But in addition to that i want to add 1 point. Generally when you are mapping a numbered list, you should always map only the code not the name. Here in your case, you should map Code -> E2 Employees. Thanks,

Sorna Raja Prabhu

Hi @RobinSilk - I have a one question? is the dimension of the module and format of a line item are same....? Thanks,

Sorna Raja Prabhu

Hi @Jsdeloria21 - Follow these steps Thanks,

Sorna Raja Prabhu

Hi @MarkTurkenburg To add a new line in text box - press ctrl + alt + Enter Note: Use left portion (ctrl and alt) of your keyboard, not right portion. Thanks,

Sorna Raja Prabhu

Hi @Sravan_Kumar, I am sorry brother. i am not 100 % clear. I assume that in abc main mod - current month line item - you except "june 20". Which should be formula driven based on abc sys mod 1 - Year (B) line item. if this is that? Then formula for current month line item is : abc sys mod 1.Year (B) Can you please elaborate more by referring respective line item. Thanks,

Sorna Raja Prabhu

Hi @Sravan_Kumar - Follow these steps to convert Text formatted date to Real DATE Thanks,

Sorna Raja Prabhu

Hi @Sravan_Kumar - Follow these steps to convert Text formatted date to Real DATE refer my previous post to get the current year or current quarter Thanks,

Sorna Raja Prabhu

Hi @kunal_311 - I did my Level 1 Model building certification very long back, i am little confused with your question. There are 2 subsets in Anaplan 1. List Subset 2. Line item Subset List subset List subsets are lists that contain a selection of items from a larger list. (in short i can say it as List within a list) - Mini List https://help.anaplan.com/anapedia/Content/Modeling/Dimensions/List%20Subsets.html Line item Subset A line item subset is a list of items drawn from one or more module line items. https://help.anaplan.com/anapedia/Content/Modeling/Dimensions/Line_Item_Subsets.html In Level 1 - they asked you to create List subset, not Line item subset Yes, subsets won't be visible under Lists and Roll-ups, i will be shown on grid view of your general list (which you have have shared - 3rd image) BUT Yes, You can see subsets below list, when you are creating a module where you want to choose which list should be the dimension of the module. All in 1 word - You are in right track, no mistake. All the best. Thanks,

Sorna Raja Prabhu

Hi @Sravan_Kumar - Create a system module: which should have 1 year formatted line item and no dimensions. You can get Anaplan System Time by writing a formula as mentioned below or you can use as existing drop down (without writing formula). Create additional 2 Line item, to get the year and to filter Apply filter and use the saved view as a source for import. Thanks,

Sorna Raja Prabhu

Hi @aakash - Scatter Chart is used to analyse 2 sets of data series. Here is an simple example. Number of Hours of Workout Calories Loss Person 1 1.0 8.0 Person 2 2.0 22.0 Person 3 3.0 35.0 Person 4 4.0 41.0 Person 5 5.0 48.0 I have created a module with persons as dimension and 2 number formatted Line items (Number of Hours of Workout, Calories Loss) Create a page in NUX Step 1: Select board or worksheet. Step 2: Drag the chart to the main screen. Step 3: Click "Configure chart" and click "View designer" to select your module. Step 4: Select the chart type as "Scatter / Bubble" Step 5: Select the line type based on analyzing the data set. Step 6: read this article to know the purpose of bubble or scatter chart : https://help.anaplan.com/anapedia/Content/New_User_Experience/Build/Visualizations/Charts/Scatter-plot-and-bubble-chart.htm?cshid=a-5f30056b-80b8-42c6-839d-a8fc0521f290 Finally i pictured correlation between Hours of workout and calories burnt. You can beautify the graph by adding labels, colors etc... Thanks,

Sorna Raja Prabhu

Hi @aakash, The purpose of Scatter Chart is to understand the relation between 2 points. To Give an Demo, i created a data set. Number of Hours of Workout Calories Loss Person 1 1.0 8.0 Person 2 2.0 22.0 Person 3 3.0 35.0 Person 4 4.0 41.0 Person 5 5.0 48.0 This data set help us to understand a correlation between number of hours of workout and calories loss across many persons. Step 1: Create a list ("Persons") and add Persons 1 -> 5, as mentioned above. Step 2: Create a Module with persons as dimensions and 2 number formatted line item (Number of Hours of Workout, Calories Loss). Step 3: Add Values to the module. Step 4: Create an app and a Page in it. Step 5: Choose either board or worksheet. Step 6: Drag chart from the right panel Step 7: Click Configure Chart Step 8: Click View Designer Step 9: Select your module, which we have created earlier. Step 10: Choose the Chart type Step 11: Based on the data set you have to choose the Line Type. Step 12: Design your graph by adding more labels, changing color etc.... Thanks,

Sorna Raja Prabhu

Hi @Rajasekhar - I think you have 2 General List (month and quarter). You can do the mapping easily using system module. Create a Module System Module -> Month List as Dimension and 1 line item (List format - Quarter) and then do mapping manually. Thanks,

Sorna Raja Prabhu

Hi @CM - To overcome this error 1. Re-upload your saved view. 2. Select your action and Click edit button and do all the mappings once again. Finally execute the action. Thanks,

Sorna Raja Prabhu · ‎06-03-2020

Hi @MarkTurkenburg - yes it is possible. First select the parent in the list and then click + . Or click any existing list member and then click + Or Use edit-> insert option . If my answer doesn't address your problem, please share the shot of the dashboard. Thanks,

Sorna Raja Prabhu · ‎06-03-2020

@Shally - For versions you can use PREVIOUSVERSION or NEXTVERSION function

Sorna Raja Prabhu · ‎06-03-2020

Hi @Shally, Use LOOKUP function. Create a System Module for mapping the list members in same list. Thanks,

Sorna Raja Prabhu · ‎06-03-2020

Hi @Younes - Change the format of Volumes line item in DAT03 Historic Volumes Module.

Sorna Raja Prabhu · ‎06-03-2020

Hi @Younes - Change the format. I Think you should change for Baseline forecast as well. Thanks,

Sorna Raja Prabhu · ‎06-03-2020

Hi @MadhabikaM - You can achieve this by using FILTER. Create a System Module with employee and Activity as Dimension and 1 Boolean formatted Line item. Mark true for the employees who are active in certain activity. can be done manually or formula depends on scenario. Apply this filter in your current module. Thanks, Sorna Raja Prabhu.

Sorna Raja Prabhu · ‎06-03-2020

Hi @CommunityMember128217 - Blank Entries meaning - you want to create a action. The purpose may be, the business don't want to share some data as a file with you. What you can do is : 1. Ask for column header(Fixed) - So that you can map accordingly while creating an action. 2. Create a CSV file and add only Column headers and run the action. Now run the action - you won't get any record in list. I am not getting what you mean " i am bit struggling to maintain blank entries in the list " Can you provide some screen shot for better understanding. Thanks, Sorna Raja Prabhu

Sorna Raja Prabhu · ‎06-03-2020

Removing from unanswered questions.

Sorna Raja Prabhu · ‎06-03-2020

Hi @MarkTurkenburg - Yes There are restriction on Time(Day). if it is transaction list or any other list act as a dimension in your source module, then your formula works. The reason you are not able to see the result in your target module is because, when ever you are coming out of Time Dimension(Built in Dimension) then an additional condition must also be mentioned in your formula. Time - Built in Dimension in Anaplan Clone Day List - is a List which you have created The Term "Coming Out" in my previous sentence means - Source has Time as Dimension Target has Custom Time List as Dimension, so you don't have TIME dimension in Target. in your Scenario - you should use TIMESUM function not SUM function. Source Module : Time as Dimension Target Module : Clone Day as Dimension An Another Example Source Module : Time as Dimension My objective is "I want to Sum the values based out of Country(Line item: TEST)" Target Module : No Time(Build it Dimension) Dimension, but Country as Dimension. The Same output as we seen in your example. So when ever you come out of Time Dimension, then Look for some Time functions in Anaplan. Hope it make sense. Thanks, Sorna Raja Prabhu

Sorna Raja Prabhu · ‎06-02-2020

Hi @anupkumar.gade - See this image, for better understanding. Thanks, Sorna Raja Prabhu

Sorna Raja Prabhu · ‎06-01-2020

Hi @anupkumar.gade, You can accomplish in 2 ways Major task is to get the 3rd, 2nd, 1st month data (Actual). Approach 1: 1. Create a system Module, where you should map current month with past 3rd month (using formula) refer this line item for calculating weighted average. apply the similar logic for getting past 2nd and 1st month data(Actual). Approach 2: 1. Try movingsum() function, i will give you an hint, check if it helps. movingsum(actual, -3,-3,sum) - to get 3rd month data apply similar for getting 2nd and 1st month Thanks, Sorna Raja Prabhu