ValueCountWhen the text parameter is a literal string as in the example below, you must insert a literal carriage return character between each item in the list. In the Specify Calculation dialog box, click the ¶ button to insert a literal carriage return character.ValueCount(“Item 1¶Item 2¶Item 3”) returns 3.ValueCount(ValueListItems(“Employees”;“Employee Names”)) returns the total number of values in the Employee Names value list in the Employees database file.