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

how about;

Count ( not isempty(File_Login_SubSheet_Brokers::Underwriter))

hth

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

Joseph

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

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

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