Controls

Re: Counting Totals Problem.

rohit — Fri, 28 Mar 2008 07:29:33 GMT

Hi Recchard,

Which code you used among the above mentioned ways.

Thanks in advanced,

Rohit

Re: Counting Totals Problem.

rcohran — Thu, 27 Mar 2008 15:22:03 GMT

Yes i did fix is sorta ... I just started a new form .. not coping data from old form. I had to RE-Create the whole thing from scrach. Adding to the form one peice at a time .. then test .. then add another .. and then it all worked. Slow process and I am still in the mist of it ..

Cheers,

Richard

Re: Counting Totals Problem.

rohit — Wed, 26 Mar 2008 10:41:14 GMT

Hi Richard,

I also stuck over here.

If you get a solution then please post it.

Thanks,

Rohit.

Re: Counting Totals Problem.

Clay Fox — Tue, 01 Jan 2008 09:27:36 GMT

If this works count(dfs:dataFields/d:tbl02Survey/@ID[../Q1 = "True"])

then I assume this works count(dfs:dataFields/d:tbl02Survey/@ID[../Q2 = "True"])

So then you should be able to add them together count(dfs:dataFields/d:tbl02Survey/@ID[../Q1 = "True"]) + count(dfs:dataFields/d:tbl02Survey/@ID[../Q2 = "True"])

Re: Counting Totals Problem.

rcohran — Mon, 31 Dec 2007 21:46:45 GMT

Greetings Clay .. I must be missing something still? I tried what you sent but maybe I am not placing it correctly cause it did not work? Here is what i have that works for counting through the "True" throgh Q1 column:

count(dfs:dataFields/d:tbl02Survey/@ID[../Q1 = "Ture"])

Tried several differnt cobos of what you sent to me but can't get any to work .. If you have a another suggestion I'd glady like to know?

Again, Thanks for any advise you can offer.

Richard

Re: Counting Totals Problem.

Clay Fox — Mon, 31 Dec 2007 19:42:21 GMT

Hey Richard, Welcome!

How about this Count (@ID[@Q1 = “True”]) + Count (@ID[@Q2 = “True”])

That should give you the total number of trues in each column combined.

Counting Totals Problem.

rcohran — Mon, 31 Dec 2007 17:48:20 GMT

Counting Totals Problem.

Hello, InfoPath in new to me but I hope to find a solution to this problem I have with retrieving a total.

I have an expression box that I desire to give a total of the number of “True” in a “ROW”.

This is an example of the Table:

Column1 Column2

Row1 Q1 Q2

Row2 True False

Row3 False False

Row4 True True

If I have this "expression box" with this formula these are my results:

Count (@ID[@Q1 = “True”])

Results equal 2 and this is correct

If I change it to:

Count (@ID[@Q1 = “True” and @Q2 = “True”])

I will get a result that equals 2. I need it to equal 3 each .. What I am looking for is to count ALL “True” entries in each row. I have 7 columns and need to count every “True” in all the rows returned.

NOTE: I did change in the second example to an “OR” and it will return the number of “True” in the first column. Like it inores the 2nd column.

Thanks for any help you might be able to provide me with.

Richard.