Simple Count Fucntion Needs Help

[Joseph31]

Hello all,

I think I have a staight forward question:

I have a Count Function that does what is says it counts a field(s)... This works great, but when there is nothing in the field(s) or a blank Field(s) that I am counting I need it to say "0"

Equation:

Count ( File_Login_SubSheet_Brokers::Underwriter )

Help,

Joseph

[Razumovsky]

how about;

Count ( not isempty(File_Login_SubSheet_Brokers::Underwriter))

hth

[Joseph31]

That does not even seem to work... am I missing something?

Joseph

[Razumovsky]

Sorry,

i am working from a machine that does not have FM installed so could not check.

You may have to create a second field calc field (num) in the original file that is

case(is empty(Underwriter), 0,1)

then use

sum(File_Login_SubSheet_Brokers::YourNewCalcField)

If you are still having problems, I can test it out tommorrow when I am back at my desk.

-Raz

[-Queue-]

That shouldn't be necessary, just deselect the 'Do not evaluate if all referenced fields are empty' option in the calculation's definition.

[Joseph31]

I am sooo Happy, Thanks guys this equation is now done... the "Do not evaluate" worked great... Thank you Queue

Thank you for the help Razumovsky....

Joseph