About praba71

praba71 · ‎02-23-2021

Hi @JaredDolich Please see the data from my file below. The third column ' Description' has double quotes in it, but to distinguish them we add \ before the double quote. If that will not solve the issue, then any suggestion on how to workaround this? Sequence,Item,Description,Org, Transaction Type,Source,Date,Transaction Quantity,Current Month,Current Quarter,Current Year,Report Timestamp 1,HDD0340,"WD 600GB SAS, 10K, 2.5\" (WD6002BKTG)",GQ1,Account alias issue,DC-CONSUMPTION,09/20/2020,1,Feb 21,Q1 FY21,FY21,02/22/2021 23:54 2,HDD0340,"WD 600GB SAS, 10K, 2.5\" (WD6002BKTG)",NEX,WIP Issue,318565,01/13/2021,8,Feb 21,Q1 FY21,FY21,02/22/2021 23:54 3,HDD0340,"WD 600GB SAS, 10K, 2.5\" (WD6002BKTG)",GQ1,Account alias issue,DC-CONSUMPTION,12/06/2020,1,Feb 21,Q1 FY21,FY21,02/22/2021 23:54 Thanks Regards Prabakaran

praba71 · ‎02-23-2021

Hi @JaredDolich thanks for the response. Just to make it clear, I am using .csv file for the data import, hence I use comma as the column separator. I do have single quote in the value of one of the text column, hence using double quote as the text delimiter. Thanks Regards Prabakaran

praba71 · ‎02-23-2021

Hi I am trying to load a data file into my module, using the navigation Action<Import Data Source but getting 'Unmatched Delimiter character '. Please see the screenshot of the error and the datafile. We want to keep double quote (") as the text delimiter for our data import. can you throw some light on what is the issue here? Thanks Prabakaran

praba71 · ‎01-09-2021

thanks @Akhtar.shahbaz @Rashmih

praba71 · ‎01-09-2021

Hi I have a line item ' Transaction Date' formatted to 'Date' . Sample value : 01-08-2021. I am trying to derive the Month,Quarter and Year from this Date value in the below sample format. Month: Jan 21 Quarter :FYQ1 FY21 Year:FY21 Is there any formulas to derive these values? Thanks Prabakaran

praba71 · ‎01-04-2021

Thanks @ChrisAHeathcote @rob_marshall @Noward for the tips. Let me try out. Thanks Regards Prabakaran

praba71 · ‎01-03-2021

Hi We are using the line item 'Month' in one of the module, and the objective is to derive the current month so that we can capture the purchase trend of our hardwares.When I try to use the formula as Month= ITEM(Time), I am getting the error message as shown in the screenshot. I have also attached the settings of the Model calendar. Also, we want the Month to display the month dynamically, i.e. In Dec '20 , it should show Dec-20 and Jan-21 in Jan'21 . Any idea how to to achieve this functionality? Thanks Regards Prabakaran

praba71 · ‎10-06-2020

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 · ‎10-06-2020

Thank you @anirudh

praba71 · ‎10-02-2020

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 · ‎10-01-2020

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 · ‎10-01-2020

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 · ‎10-01-2020

Thanks @Jitendra.Vishnolia ..It helped.

praba71 · ‎10-01-2020

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 · ‎09-29-2020

Thanks Sandeep for the help..

praba71 · ‎09-28-2020

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

praba71 · ‎09-28-2020

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 · ‎09-28-2020

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

praba71 · ‎09-28-2020

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 · ‎09-28-2020

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 · ‎09-27-2020

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 · ‎09-27-2020

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 @ChrisAHeathcote @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 @ChrisAHeathcote