These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Count Items in Subform

2011-11-22 13:47:48

tgizmo

Registered: Jun 14 2009

Posts: 8

Answered

I've done this before but can't remember how.
I have a LiveCycle form with 20 rows (instances) of employee data. One of the employee fields is gender (drop-down, "M" or "F").

How do I count the number of Males and Females in a summary form? Similar to countif function in Excel but ???. I apologize for the stupid question and appreciate any help.

My Product Information:
LiveCycle Designer, Windows

2011-11-22 23:25:53

radzmar

Registered: Nov 3 2008

Posts: 1202

Accepted Answer

You can do this with a loop.

This script in the calculate:Event will count all rawValues of fields "Cell2" in all instances of Row1.

var M = 0;
var F = 0;
for (var i=0; i < xfa.resolveNodes("Table1.Row1[*].Cell2").length; i++) {
	if (xfa.resolveNode("Table1.Row1[" + i + "].Cell2").rawValue === "m") {
		M++;
	} 
	else if (xfa.resolveNode("Table1.Row1[" + i + "].Cell2").rawValue === "f") {
		F++;
	}
}
 
this.rawValue = M.toString() + "/" + F.toString();

radzmar
• LoveCycle Blog
Documents you need:
• LiveCycle Designer ES2 Docs