Calculate checkboxes

[Dana G]

[color:blue]I have a field called "rfi_category" that is formatted as a checkbox with 8 values. "CC", "CI", "CL" "CODE", "DI", "IR", VI", "WM" are the values.

I have created calculation fields for each that state: If (rfi_category = "CC"; 1;0)

[color:blue]I have also created summary fields for each that state: Total of "count_cc" (running)

The summary fields are the ones that I have placed on my layout, however all of the fields show "0" even if all of the check boxes are checked.

Am I missing something?

[Dana G]

Well I have figured it out myself.

For any others that may need the answer:

[color:red]count_cl=

PatternCount (rfi_category; "CL")

//will return number of boxes checked for this value throughout found record set//

Then you will need to create a Summary field that will state: [color:red]Total of count_cl (running).

[Vaughan]

"If (rfi_category = "CC"; 1;0)"

This can be simplified to

rfi_category = "CC"

since it will evaluate to 1 if true, and 0 if false.

" count_cl=PatternCount (rfi_category; "CL") "

This will also count entrie such as "HCL" as true. To avoid this, check paragraph-delimited values...

PatternCount ("P" & rfi_category & "P"; "P" & "CL" & "P")

... where "P" is really the paragraph pilcrow symbol.

The paragraphs don't have to be explicitly expressed as I have them above, but it makes it a bit clearer to explain what's going on if there are IMHO.