Counting Value List Item

[HollidaySlim]

Hello All,

I am new here and looking for a little help on a problem. I have a database with one table in it called "Leads V1.2".

I want to create a field with a calculation that will count how many times a value is selected from a drop down field called "Confirmed Results". IE. I have a field (drop down) that is called "Confirmed Results" That field is populated with a value list called "Confirmed Results". This value list has a value called "Confirmed". I then created a calculation field where I used the commands

Count ( "Confirm Result" ; ValueListItems ( "Confirmed Results" ; "Confirmed" ))

. But this is not working. I hope I provided enough detail to get the point across of what I am trying to do. So what am i missing here and how do I create a field that will count how many times "Confirmed" is entered into the field "Confirmed Results" TIA for any help.

Matt

[Søren Dyhr]

Use Ugo's method instead:

http://fmforums.com/forum/showpost.php?post/266487/

--sd

[HollidaySlim]

Thanks!

I don't think that achieves what I want though. I guess I should have been more specific in my OP. I need this to calculate for all records, for a summary of sorts I guess.

[ddreese]

I'm not sure if this is what you're looking for or not.

1. Create text field with global storage (we call these globals) in your table.

2. Create a new table occurrence of your leads table, use the new global field in your original table occurance and link it to the "confirmed results" field.

3. Create a calculation field using the relationship you just created. For example:

CALC_confirmed_count

count(your_new_table_occurence_relationship_name::primary_key_of_table)

4. Type the value of whatever you want to "count" in your new global field (use a drop-down if you want), and the calculation field you just created should display the count.

If you upload a clone of your database we can fix this up real quickly for you.

[HollidaySlim]

I think what you mentioned there just might work. Here is a clone of my DB.

Leads_V1.2_Copy.zip

Edited April 16, 2009 by Guest
Added File

[ddreese]

Here you are. I noticed that you may only be interested in the "Confirmed" count, but this gives you a bit more flexibility, as you can search for the other confirmation types as well.

Leads_V1.2_Copy.zip

[HollidaySlim]

That is awesome!! Thank you very much!

[Søren Dyhr]

Is it? Two problems....

1) What happens if accidental scripting tampers with the global value?

2) Aggregate functions doesn't scale particular well, the rendering gets slow as molases if the number of records exceeds 2k ...

--sd

UgoTillYouDrop.zip