I have this calculation:

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

It counts companys in a portal... But it displays a "1" count when there is nothing there. When I add a company it still shows "1", when I add another company it shows "2".

So the question is what is it counting when there is nothing there.

I have uncheck do not display when feilds are empty and that does not help.

Joseph

So the question is what is it counting when there is nothing there

Hi,

it is counting your [& "¶"] in your calc:

PatternCount ( ValueListItems ( Get ( FileName); "Rel_Company" ) [color:red]& "¶" ; "¶" )

You have to use this calculation (unstored)

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

Well I tried that formula... and it still says 1 when there is nothing in that field?

This is too weird.

Joseph

I figured it out... I have a white space in the value list... I use this for when I do not have a company listed on an entry.. so when I do not see anything there is something really there its counting the white space.

Thanks to every one

Joseph