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")