Calculating Text input Help.

[Faldo]

Hi wonder if someone can help.

I have a field which is y or no for attendance.  How can I count all the Y and also seperately the N to give a total of each.

Thanks very much for any help.

[Agnes Riley]

I would use 1 for attendance and nothing for not attending. And the Sum function works very well if you do a search for the 1 in the field or nothing aka = sign.

[Faldo]

Ok so i can put a search in that field for either 0 or 1 and sum them?

Will give it a shot if thats the case.

Thanks again.

[Faldo]

Ah never thought,,the sum will only count the 1's

thanks

[comment]

Do you even need both types of records? After all, anyone not attending is absent and vice versa - so unless you have something additional to record about both attendances and absences, one of the types is redundant.

[iking42]

Why not use a short toggle script and a button field so the user can click the attendance box and change it from a Yes to a No, No to Yes, 1 to 0, 0 to 1, etc. without ever touching the keyboard. This is very user friendly and works great. If text is what you want, include a simple calculation field in each record where [ If (text_field = "yes"; 1; 0)] and sum on that field.

 

Good Luck

Knucklehead

[comment]

 If text is what you want, include a simple calculation field in each record where [ If (text_field = "yes"; 1; 0)] and sum on that field.

 

No, that's not a good idea, for several reasons. For one, if you ever want to change the displayed text, you need to change the value list AND the calculation formula AND modify existing records. The correct order is: if text is what you want to display, include a simple calculation field where:

 

If ( Statusfield ; "Some text" )

 

or just place the text directly on the layout and format it conditionally to appear when Statusfield is true. Or - if it's a short text, like "Yes" and "No" - format the field to display as Boolean.