Count items

[hung pham]

Hi,

How do I count number of items in the drop down list?

Thank you in advance.

Hung Pham

[bobsmith]

If each item in your value list is a single word you can use this calculation.

WordCount(ValueListItems ( "dbname" , "valuelist" )))

Note: be sure to use "" around dbname and around the valulist name otherwise FM will look for a field. If some or all the items in the value list are more than one word I would have to see examples to work that out>