Count

Use this command to return the number of items in a list. This command can be used with either a list variable, symbol, or a file name.

Note: Only those symbols to which the user has access will be included in the return list.

COUNT (Variable)
COUNT ("DimName", "SymName#")
COUNT ("ScheduleName", "DimName", "SymName#")        
COUNT ("FileName")        

where:

• "Variable" is the name of a variable.
• "DimName" is the name of a dimension containing the symbols.
• Schedule is the name of a schedule.
• SymName# is the name of a symbol and any relevant symbol hierarchy specification.
• FileName is the name of a file. In this case, the COUNT function returns the number of lines in a text file. This may be useful if you want to verify the record counts output to log files generated.

  Note: If only one parameter is specified, the function will check the validity of the parameter in the following order:

  • valid variable name
  • valid file in memory
  • valid physical file name

CREATE VARIABLE Count1[] AS String
CREATE VARIABLE CNT as NUM
SET VARIABLE Count1 = "P01ytd | p02ytd"
SET VARIABLE CNT = count ("Count1")            

CREATE VARIABLE List
CREATE VARIABLE listcount
CREATE VARIABLE listcount2
CREATE VARIABLE listcount3
SET VARIABLE List = CreateList("Symbols", "Database" "Accounts", "TrialBalance###")
SET VARIABLE listcount = Count(List)
SET VARIABLE listcount2 = Count(Accounts, TrialBalance###)