Need a calc field to.. count # fields same record are blank?

[RodM]

Hope this is Left brain stuff..

 

I have a single record, there are 5 global field1, field2 field3 etc

I need  a calc global field, to show how many are empty of those filled in

 

Can't figure..

TIA

R

[eos]

to show how many are empty of those filled in

 

Not sure I understand this last sentence; I assume you want to count the number of empty globals:

Sum
( 
  IsEmpty ( globalField1 ) ;
  IsEmpty ( globalField2 ) ; 
  IsEmpty ( globalField3 ) ; 
  IsEmpty ( globalField4 ) ; 
  IsEmpty ( globalField5 )
)

[David Jondreau]

ValueCount ( List ( globalField1 ; globalField2 ; globalField3 ; globalField4 ; globalField5 ) )

[Lee Smith]

I was thinking that Rod was looking for a way to know which fields were empty.

 

 

Case ( IsEmpty ( globalField1 ) ; "globalField1" & ", " ; "" ) &

Case ( IsEmpty ( globalField2 ) ; "globalField2" & ", " ; "" ) &

Case ( IsEmpty ( globalField3 ) ; "globalField3" & ", " ; "" ) &

Case ( IsEmpty ( globalField4 ) ; "globalField4" & ", " ; "" ) &

Case ( IsEmpty ( globalField5 ) ; "globalField5" & ", " ; "" )

[LaRetta]

Rod said, "...to show how many are empty of those filled in"

 

Count ( field1 ; field2 ; field3 ; field4 ; field5 ) will count how many have any value so if you have 5 fields are want to know how many are empty, it could be:

 

5 - Count ( field1 ; field2 ; field3 ; field4 ; field5 )

 

Don't ya just love how there are so many approaches with FileMaker?  Take your pick, Rod!!    

[eos]

Don't ya just love how there are so many approaches with FileMaker?  Take your pick, Rod!!    

 

Yeah, nice to have so many approaches towards an unidentified goal. 

[LaRetta]

Actually I thought Rod was very clear in his need. 

[RodM]

Thanks you all...

 

I liked this one

 

Sum
( 
  IsEmpty ( globalField1 ) ;
  IsEmpty ( globalField2 ) ; 
  IsEmpty ( globalField3 ) ; 
  IsEmpty ( globalField4 ) ; 
  IsEmpty ( globalField5 )
)

 

I might allow 5 agents to log in..

As agents log in, I populate one of the GlobalFields with their persistent_ID  ( is that long not used for anything id)...

I think this calc field now, will let me have a count of still avail agents or if all are agents log out, maybe run another admin routine.