August 29, 200520 yr [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?
August 29, 200520 yr Author 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).
August 29, 200520 yr "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.
Create an account or sign in to comment