create a summary field that sums the values of a calculated field:
If( checkbox = "Y" ; 1 )
I tried to create a calculation field with the described code, but it did not work. is there some special way to create a summary field with a calculation in it?
What doesn't work in that calculation ?
Which is the custom value list attached to that checkbox ?
the fields are
N when i try to put in an new calulation field that links the field "fieldname A" to the new field via the calculation you gave me, it will count some of the "n"s as Y's
Why did you use a field ( "fieldname A" ) formatted as checkbox with 2 checkbox ( Yes and Not ) instead of using radio buttons ?
Most likely there are now some records that have both checkbox cheked !!
Try to make a find for *Y* and go to fix the anomalies. ( same with *N* ).
lol sorry they are radio buttons
To search a reason to understand why my calc isn't working, place another occurrence of that "radio-button" field into the layout, format it as a simple "Edit Box", and do the above mentioned find from that field.