1 Reply Latest reply on Jun 9, 2011 3:10 PM by philmodjunk

    sum or count calculation with filter?

    kilbot

      Title

      sum or count calculation with filter?

      Post

      I have 600 records and I want to count how many different names I have in a field.

      So if the name bob was used 300 times it would only count it once. I want to place this in the footer of my layout.

        • 1. Re: sum or count calculation with filter?
          philmodjunk

          Here's one way to do this.

          Set up a value list that refers to this field. In the value list, "bob" will only appear once.

          Then this calculation will count the number of different values in your value list--which will be the number of unique values in your field:

          ValueCount ( ValueListItems ( Get ( FileName ) ; "valueListNameInQuotes" ) )