Calc Needed to Count Items

[Joseph31]

Hey,

This might be an easy one. I need a calcultaion to count items in a portal. But here is the tricky part... I do not want to count duplicates. The field I want to count is in a portal and it is a pull down menu.

Is there a easy way to count items in a field without count all the duplicates.

Example:

Company Name

ABC Plumbing

XYZ Bolts

ABC Plumbing

the count would only be 2

Thank you,

Joseph

[-Queue-]

Create a value list of the related field, starting from the parent table, and an unstored calculation of ValueCount( Get(FileName); "yourValueList" ).

[Joseph31]

I have done both of those things... is there any thing else I am not doing... all that is displayed is the number 1 even when there are more than one listing in the portal.

I used this:

PatternCount ( ValueListItems ( Get ( FileName); "Related_LE_Main" ) & "¶";"¶" )

Where Related_LE_Main is a value List custom Define from the table

Joseph

Edited August 23, 2005 by Guest

[Vaughan]

Make the calculation unstored.

[Joseph31]

Did that too... But I still see a number 1? Is there anything like a relationship i should have or anything like that?

Joseph

[LaRetta]

"is a value List custom Define from the table"

Custom? A Custom value list won't count your related.

"Is there anything like a relationship i should have or anything like that?"

Yes. The value list must be based upon values from field, all values and point to your other table occurrence of Related_LE_Main - the same relationship your portal is based upon. :wink2:

[sbg2]

Did that too... But I still see a number 1? Is there anything like a relationship i should have or anything like that?

Create a sample file, zip it and post it here so someone can show you by example.

[Joseph31]

OK Guys thank you for all of the help... It works now... I had my name wrong in the value list that was in the equation... Wow that does get hard when you have so many items. Thank you again.

Joseph