Skip to content

Trc_Ws_TreeItemCount

Counts the tree items of a workspace tree items object.

Function Parameters

Parameter 1

Workspace. E.g. Sales.

Parameter 2

Tree items objects of the selected workspace. E.g. TreeItemsCustomerABC.

Samples

Shows the number of items in the items object.

=TRC_WS_TREEITEMSCOUNT("Sales";"TreeItemsCustomerABC")

sample

Assistant Window

The assistant window can be used to generate a funtion.

1. Workspace Items

In the left area, the user must select a workspace. In the right area the items objects of the selected workspace are displayed.

workspace-items

2. Finish

After finish the function is placed in the selected cell of the worksheet.

=TRC_WS_TREEITEMSCOUNT("Sales";"TreeItemsCustomerABC")