What is difference between: ITEM & FINDITEM
Best Answers
-
ITEM returns the dimension in a module. FINDITEM returns the format of the line item and ignores the dimensions in the module1
-
Item: Returns the list item of a List formatted or Time Period formatted line item
Ex. ITEM('Products') will return the item in the list to the list formatted line item
FindItem: Matches a text string to the Name or Code of List Items and returns the list item of a List Formatted or Time Period formatted line item
Ex. FINDITEM('Products', 'Products Text') will match the text string in the line item 'Products Text' to the item in the Products list, and return the list item in the Products List
1
Answers
-
Please refer below link to find the differences
https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/ITEM.html
https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/FINDITEM.html
Thanks
Akhtar
0