About praba71

praba71

Hi In the attached screen shot of my dashboard,I want to count the number of unique values in the Item column and display the count value near the title 'Comp Reservation Details'.Any help for the formula/workaround is appreciated. Thanks Regards Prabakaran

praba71

Thank you @anirudh

praba71

thanks @anirudh @Jitendra.Vishnolia for the response.. It worked. Now,is it possible to hide the line item which holds the constant value for conditional formatting, from the user view? Is there any workaround available, apart

praba71

Hi @anirudh Thanks for the response. Conditional formatting will not help here, since irrespective of the values in the column ,I want to highlight all the data in a column in one color. Please let me know if there is any workaround to achieve this. Regards Prabakaran

praba71

Hi Is there any way we can add background color to select few columns in a Module/Dashboard? We want to highlight the data in certain columns to the users. Thanks Regards Prabakaran

praba71

Thanks @Jitendra.Vishnolia ..It helped.

praba71

Hi I am trying to load data from .csv file into Module using import option. Data from one column 'PO Approved Date' is not getting loaded into the module.Please see the screen shots attached. Any help would be appreciated. Thanks Regards Prabakaran

praba71

Thanks Sandeep for the help..

praba71

thanks @rob_marshall @ChrisHeathcote for the inputs.. Regards Prabakaran

praba71

Thanks @rob_marshall .. Will try our your suggestion. Once correction.. What I meant by Last Quarter is the Quarter that preceded the current one. eg. Current Quarter is Q3FY20 and I want to fetch Q2FY20 through a formula.. Sorry for the confusion. Is there any formula to capture the previous time periods? Regards Prabakaran

praba71

Thanks @sandeep_bk .. Sent you the request. Regards Prabakaran

praba71

Hello @sandeep_bk Thanks a lot for the details.. But, I am still missing something, it seems, Please see the screen shots attached, after the setups, in the target module, I dont see the Consumption column showing the subset values. It is still showing as one column. Would appreciate if we can connect in a short google hangout call to sort this out, if that is possible. Again, thanks for your time. Regards Prabakaran

praba71

Hi @anirudh Thanks for the response. When I follow your steps, i am getting error message when entering the formula for Transaction Qty Quarter. Please see the screen shot attached. Thanks Regards Prabakaran

praba71

Hi I am trying to use a formula to fetch the last quarter and last half year. I have a line item 'Current Quarter' in my module which has the current quarter. ex.Q3 FY20. I want to apply formula on this line item to get the last quarter and last half year values. Any help is appreciated . Thanks Regarrds Prabakaran

praba71

Thanks @sandeep_bk .. I will check this one out. Regards Prabakaran

praba71 · ‎09-25-2020

Hi @sandeep_bk thanks for the details. I am stuck up at setting up the staging consumption module. Please see the screen shots. 1) I created a custom list 'Consumption Period' which has Month, Half year, Year and Quarter. 2) Then I created a Line item subset 'LIS' for my columns Last_Month,Last_Quarter,Half year and Year. 3) Then I created a mapping module'LIS Mapping' to map 1 and 2. 4) Then I created a staging module 'Staging consumption' where I am trying to use the collect formula. But this is where I am getting error. Can you please suggest where I went wrong? Thanks Regards Prabakaran

praba71 · ‎09-25-2020

Hi @scbaker We are talking about only one type of hardware here.The data file will have hundreds of records for each SKU and we will be loading this data into a List, Thanks Regards Prabakaran

praba71 · ‎09-24-2020

Hello Need some help in setting up a module for our requirement. We are tracking the consumption of certain hardwares at our facility. The data file looks like this, where the numbers are the consumption qty in that month.We will be getting this data every day with rolling months, meaning on Oct 1st we will get the new column Oct '20 in the file ,for the consumption in Oct as on that date. Jan'20 Feb'20 Mar'20 Apr'20 May '20 June '20 July '20 Aug '20 Sep '20 110 85 130 105 125 98 105 138 142 Now, the requirement is, to calculate the qty for the current month, current Quarter, Last Quarter and current year. Consumption current month Consumption current Quarter Consumption last Quarter Consumption current year The Quarters need to be considered dynamically as per calendar. i.e. On Sep 24,the current Quarter will be the period July-Sep, and on Oct 1st, the period will be Oct-Dec. Any suggestion on how to achieve this in Anaplan? Thanks in advance Prabakaran

praba71 · ‎09-24-2020

@sandeep_bk in the screen shot showing the setup for staging consumption, you have used a list P1. Whats this list for? Thanks Regards Prabakaran

praba71 · ‎09-21-2020

Thanks @ChrisHeathcote @sandeep_bk for the detailed response .. Much appreciated..

praba71 · ‎09-18-2020

Hi @sandeep_bk Thanks for the response. As you suggested, I created a list 'Consumption Period' containing Month,Half Year, Quarter, Year. Then I created an item subset LIS by choosing the items Last Month,Last Quarter, Half year and Year from the module 'Comp Consumption History'. Now, I am trying to map these two ( List and Item subset) and seem to be lost. Can you please provide some lead here to complete the setup? Thanks Regards Prabakaran

praba71 · ‎09-17-2020

Hi Need help in setting a column up in our module. We have four separate columns , Cons_Last Month, Cons_Last Quarter, Cons_Last_Half Year, Cons_Last_Year, which are the numbers of past historical consumption quantity of a particular sku. For better presentation, we want to show all these under one column header ' Consumption' as shown in the attached screen shot. Any help on how to achieve is appreciated. Thanks Regards Prabakaran

praba71 · ‎09-17-2020

Thanks @ChrisHeathcote

praba71 · ‎09-14-2020

Thanks @nathan_rudman for the response.. I am using the below formula for the column 'Structure Type. RANK(JOB_NAME, DESCENDING, MINIMUM,JOB_NAME>0, PARENT(ITEM(ASSEMBLY_CONFIG))). But I am getting the attached error. Can you please throw some light on this error and how to fix? Thanks Regards Prabakaran

praba71 · ‎09-14-2020

Hi Please refer the screen shot attached. Within a parent,I want to sequence the column 'Structure Type' based on each unique Job Name.For example, for Job Name 318317,I have marked 1 and 2 for 317542. Need to know how to setup the formula for the column 'Structure Type' for this requirement. Thanks Regards Prabakaran

praba71 · ‎09-10-2020

Thanks @kawula.p @ChrisHeathcote for the response. Just to make it clear, our requirement is to build the different combinations of components that make up a parent in anaplan so that when we have a demand for a parent, we can analyze which combination will work out best. One parent will have two components and we have multiple combinations (6-7) for a parent. Would appreciate if you provide me some simple screenshots for this, as I am still trying to understand your suggestions. Thanks very much Regards Prabakaran

praba71 · ‎09-08-2020

Hi Need your help in developing a solution for this requirement. Please see the attached data sheet.We execute Jobs to make Assembly Items by consuming Comp Item numbers (Typically we consume 2 types of Comp item numbers to make one Assembly item). One Assembly item can be made in more than one way.(i.e. We can create two different jobs to consume two different sets of Comp item numbers to make the same Assembly item).Assembly items and some of the comp item numbers have the Configurations attributes assigned to them. Now requirements is to setup a hierarchy in Anaplan to show for each Assembly Item configuration, what are the different combinations of Comp Item number configurations that we have used. This dataset will help us to consolidate the required quantity of Comp Item number configurations for the future demand of Assembly item configurations. Planner will then plan his/her procurement of the Comp item number configurations based on this consolidated list. Thanks in advance Regards Prabakaran

praba71 · ‎09-04-2020

Hi @chenjack.sonos thanks for your update. Can you please be more detailed in your suggestion ? If possible, can you please provide some screenshots? Thanks Regards Prabakaran

praba71 · ‎09-03-2020

Hello Arun Thanks for the response. My current parent is the Assembly Config (ex.C-4K/768/960). I want to have Job name as subparent under the Assembly config and Component item as children under the Job Name. Please let me know if you need more details. Thanks Regards Prabakaran

praba71 · ‎09-03-2020

Hi Please refer the screenshot, we would like to further subgroup the records under each parent based on the job name. ex. for example, for the parent 'C-4K/768/960, there are 6 records, with two records for a job name. We would like to further subgroup the 6 records within a parent, based on Job name. Please see the second screen shot attached. Can you suggest how to achieve this hierarchy in anaplan? Thanks Regards Prabakaran

Online Status	Offline
Date Last Visited	3 weeks ago