Formula Help

[Joseph31]

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

[Raybaudi]

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" ) )

[Joseph31]

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

This is too weird.

Joseph

[Joseph31]

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