About TonyViGrand

TonyViGrand · ‎02-12-2022

Hi @CHSJ I will give below my solution once again in steps based on the mock up you have shared. 1) First create another module and lets name it as "StagingModule" dimensioned by List 1. 2) Create two line items and lets name it as "LineItem1 & "LineItem2". 3) The format of LineItem1 will be List 1 formatted line item. 4) The format of lineItem2 will be List 2 formatted line item. 5) In LineItem1, the formula should be ITEM('List 1') 6) In LineItem2, the formula should be FINDITEM('List 2',left(name(item('List 1')),3)). 7) Now back to your original module showed in the mock where you want the result. You can put the formula in the product line item as 'StagingModule'.'LineItem1'[FIRSTNONBLANK:'StagingModule'.'LineItem2']. See to that when you input the formula you put the brackets correctly otherwise you might get the formula invalid error. If any error, please do share the error screenshots and blueprint view of the module and formula you have put. Hope this helps. Regards, Tony

TonyViGrand · ‎02-12-2022

Hi @jbaudino1 Try using either firstnonblank or lastnonblank instead of lookup. Eg; Input03Module.finalsegmentcountry[firstnonblank:D33Salesproperties.Rep] Hope this helps. Regards, Tony

TonyViGrand · ‎02-12-2022

You can put the above formula in the target module line item itself. You don't need the mapping module I created.

TonyViGrand · ‎02-12-2022

If that is the case, then its easy. You can put the formula as finditem('List 2', left(name(item('List 1')),3)) Hope this helps.

TonyViGrand · ‎02-12-2022

Hi @AnyaS Maybe you have a look at this page. It might help and give you some contents which are considered on the roadmap. There are some filters at the left side of page where you can select the Data Integration Filter and then select "Considered for Future Roadmap" or "On Roadmap" Filter. Idea Exchange - Anaplan Community Regards, Tony

TonyViGrand · ‎02-12-2022

Hi @CHSJ Please refer the below screenshots, the formulas are available in screenshots. Note: The list used in target module is "List 1" and the list used in Mapping module is "List 2". Hope this helps. Regards, Tony

TonyViGrand · ‎02-12-2022

Hi @MaithriK Please refer the screenshot below, I have given the formula in it. Hope this helps. Regards, Tony

TonyViGrand · ‎02-06-2022

Hi @algrigore The reason why the formula is not working is because the dimension in "DIM00_Input Data" Module and the dimensions in these modules "ATT05", "ATT12", "ATT09", "ATT16", "ATT15", "ATT02" which are referenced in the "check" line item are different. And so the formula is looking to the parent or top level of these modules to fetch the data and it is turning out to be empty. You can either put the formula using code function and reference the line item in the same module for each like below: isblank(code('Company Code') & code ('Product Family') & Code('Ownership') & code('Chart of Account') & code('Market') & code ('Local Currency')) or you can reference the "ATT05", "ATT12", "ATT09", "ATT16", "ATT15", "ATT02" line item in the module and use lookup after each reference like below isblank('ATT05 CMC02 Company Code L2'.code[lookup:'Company Code'] & 'ATT12 module'.code[lookup:'Product Family'] & 'ATT09 module'.code[lookup:'Ownership'] & 'ATT16 module'.code[lookup:'Chart of Account'] & 'ATT15 module'.code[lookup:'Market'] & 'ATT02 module'.code[lookup:'Local Currency']) I am not sure exactly whats you scenario but if your scenario is to check if any of the 6 line items is empty then the "check" must become true , then instead of using Isblank the above way, you should use the formula as isblank('company code') or isblank('product family') or isblank('ownership') or code('Chart of Account') or isblank('Market') or isblank('Local Currency') Hope this helps. Regards, Tony

TonyViGrand · ‎02-05-2022

Hi @algrigore You wanted the formula to be put in Local Currency Line Item in DIM00_Input Data Module right? Try this formula: 'ATT05 CMC02 Company Code L2'.'Currency (CUR01)'[Lookup:'Company Code'] Regards, Tony

TonyViGrand · ‎01-27-2022

Yes, but as I see there is no consistent formula which we can put for all the list items in your problem. I think there is no other way. We would be having the sparsity.

TonyViGrand · ‎01-27-2022

Hi @Saisri8568 I have created a mapping table and two line items and using this I have got the result you expected. The reason I created this mapping table is because on the example you gave the formula for other list items like e,f,g and the formula looks random. So this way by creating mapping table and using the formulas in target module and calculation module I have put, you can easily get the expected result. Please refer to below screenshots. Hope this helps. Thanks Tony

TonyViGrand · ‎01-23-2022

Hi @Chmacpherson I assume the timescale in the destination module is "Day", if that is the case then you can try the formula as Data from source [Firstnonblank:Employee ID,firstnonblank:EffectiveDate] . If the timescale is month in destination, then first create a line item example "EffectiveMonth" in source module to convert the date into month using the Period formula and then use the above formula with instead of EffectiveDate line item in firstnonblank, you could use EffectiveMonth line item. Thanks Tony

TonyViGrand · ‎04-24-2021

Hi @neg177 I have created a solution with simple test module which will give the 10th day of the month and if 10th is a weekend then it gives the next business day of the month. In case if you are looking for a solution which gives the 10th working day or business day of every month excluding all weekends then the below snip will help you. Hope one of the above solutions will help you. Regards, Tony Grand

TonyViGrand · ‎03-24-2021

@SaraBTIT I have an idea which might help you to get the users with write access. First, import the "Write" column of the Fake Users List to a module with a text formatted line item dimensioned by "Fake Users" List. Next, create another module dimensioned by Inbuilt "Users" List and "Fake users" List and create a line item with "Users" list as the format. Keep the summary as First non blank. Put a formula using Find function in the line item to separate the users as shared in screenshot below. Create another line item with just Users list as dimension and as line item format too and you can reference the previous line item to it. Now this new line item will have all the users having Write Access to the dummy users list. Hope this helps. Tony Grand

TonyViGrand · ‎03-23-2021

@hinamahmood1994 First Check whether the time summary of the source module is not "None". Then, assuming you have "All Periods" in time dimension, you can give the formula as isnotblank( MeldalisteSales [Select:Time.'All Periods']). Hope this helps

TonyViGrand · ‎03-23-2021

@Yashabh I have seen a similar post which could help. Solved: Re: Count Duplicates Based on Text Field - Anaplan Community The rows in Duplicates line item which have number more than 1 are the duplicates. I have shared screenshots which could help you too. Hoping this will solve your problem. Tony Grand

TonyViGrand · ‎03-19-2021

@xin Yes , It can be done. I have created a sample below to show how it can be done. First step, Create a line item "Scenario to be Imported" with no dimensions and the line item format should be the scenario list. Second, Create another line item "Filter Scenario" with scenario list as dimension and boolean as format and put formula as Item(Scenario)=Scenario to be Imported. Third step, In the source view for the import, Select the Filter and in the scenario tab, use the "Filter Scenario" line item from the filter module for filtering only the scenario you wanted and save the view. Now in "Scenario to be Imported" line item of the Filter Module, Select the Scenario which you wanted to import and using the view you created in third step as source ,you will be able to import to the target module only the data from the scenario you wanted from the source module(In this case its Scenario 2) Tony Grand

TonyViGrand · ‎03-19-2021

@KevinMcQuillen I don't think this problem can be specifically said only to NUX. I have experienced this problem occasionally in other applications too like MS Word, Excel, Edge browser, chrome browser, etc.. This could happen because of various reasons like many tabs are open and are loading something, or number of applications are kept open and not exited. Here is a link which Microsoft has put which could give you some description about this problem : The scroll bar continues to scroll after you release the mouse button (microsoft.com)