About NilanjanDutta

Hi, I am trying to achieve the following output in Final Value line item. 1) Till the first override the system should take the Value line 2) Once Override is checked, the system should take the override value and copy it across the remaining timeline unless a new override is done Can someone please help in defining the logic for the final value line item? Thanks, Nilanjan ... View more

Hi, I have built a dependent dropdown but its not functioning properly. I have a hierarchy which follows the certain order: Entity>Segment>Product Below is my segment hierarchy Below are my line items which are list formatted When I am selecting the top level of Entity, my segment dropdown is showing entity list and on selecting one entity from the list, its giving an error. Infact it should show that there are no items in the list Is there a way where my segment list gets locked or shows no items when I am selecting the top level of entity? ... View more

我发表一项list-formattedon my dashboard and i am using it as a filter. But everytime I select a new list item from the drop-down, I have to refresh the dashboard for the filter to refresh and to see the changes in the grid below. Is there a way to auto-refresh the dashboard once the filter is changed? ... View more

I want to pull the description details from the History log. I have calculated the number of commas before the Description column which is 3 but I am not able to find the position after the 3rd comma to extract the Description data for multiple rows. Row 1 - ID,Date/Time (UTC),User,Description,Security Change,Previous Value,New Value Row 2 - 2077909,17-10-2020 14:24,tabc@abc.com,Bulk Change,,, Please share your approach. ... View more

你好,我需要一些澄清关于他的tory log. There are some columns in the log which represents individual lists and there are some lists which are not a part of the log. So my question here is which lists under general lists are part of the log as separate columns and which lists are not.? ... View more

I am trying to identify if the amount entered is in correct format and also if it is Blank or not. In order to achieve that I am importing the amount in both text and numbered line item. - Below are the different results we get when we import the amount in different formats in text and numbered line AMT_Text AMT_Number 12,3/45 12345 12,345.46 12345.46 64,36 6436 A 0 12A 12 0.1A 0.1 //1//\ 1 AS123 123 //0.987 0.987 Ab//76 76 ;'/1 1 we342 342 12//32 1232 12345 12345 12//// 12 12//13 1213 //12.234 12.234 0.98 0.98 .//98 0.98 ,87,89 8789 123.234 123.234 0.7764 0.7764 12,23,4.45 12234.45 1,34,235.66 134235.7 12..13 0 12>>13 1213 0 Can someone please share some idea on how to identify the invalid entries from the valid ones? ... View more

Currently I have transactions which run in Lakhs. I am trying to bring in a comment again every transaction by copying down but Anaplan has a limitation saying that only 10000 rows can be copied at a single time. Even I tried the conventional method Ctrl+C and Ctrl+V but still its the same issue. Is there any workaround this issue? ... View more

Hi, I was trying to take export in form of .xls where each item in my page selector should get copied to an individual tab in Excel and the tab name should get renamed as that of the page selector. I was able to get individual copies from each page selector in separate tabs by Exporting in Grid view and selecting All Pages option but the renaming of the tabs is where I stuck right now. The tabs are named as Sheet 1, Sheet 2, Sheet 3 and so on after the Export. Let me know if anyone have some suggestions. ... View more