Count items in a value list

[barrettrm]

hi, I would like to count the number of items contained in a value list that is defined by a calculation. I have a field that displays the value list like this:

CIO

CW

NWW

I'd like to to be able to count this list so I can provide conditional formatting to a field if the list has more than one item.

Any suggestions? Thanks.

[comment]

I am not sure what exactly "a value list that is defined by a calculation" means, but try the ValueCount() function.

[barrettrm]

Thank for your response -- I tried this:

ValueCount ( PROJECTS::project_business_units) > 1

but it's not working. projects_business_units is my field that contains values like:

CXO

or

CXO

CW

or

CXO

CW

NWW

and I'm trying to count the number of items.

Any further suggestions? Thanks again.

[comment]

I don't know - does this work for you?

CountValues.zip

[barrettrm]

Yes, that works for me! I actually see that my problem was related to something different but your example helped. Thanks again!