General

Re: Count for each distinct value

jeanpaulhanna — Wed, 22 Apr 2009 19:12:36 GMT

I figured it out....

count(../my:LIENS[(my:LIEN_TYPE = current()/my:LIEN_TYPE)])

Re: Count for each distinct value

jeanpaulhanna — Sat, 18 Apr 2009 22:40:53 GMT

thank you for your reply....

That would work if the values were static....the list that I provided was just an example of the values, and I will not always know what values will be.

Re: Count for each distinct value

swathip — Sat, 18 Apr 2009 04:56:57 GMT

Hi,

Add an expression box/ text box to the form. Add the below expression as default value.

count(../my:group1/my:group2[my:field1 = "Building Loan Agreement"])

Here group2 is the repeating table and field1 is the field value which stores the values you have mentioned (Building Loan Agreement, ..)

The above expression will give the count for ‘Building Loan Agreement'.

Use the same for other values by replacing the ‘Building Loan Agreement' value with ‘Lis Pendens' / ‘Mechanics Lien'

Count for each distinct value

jeanpaulhanna — Fri, 17 Apr 2009 19:53:53 GMT

I have a repeating table where I am filtering by distinct value

not(my:LIEN_TYPE = preceding::my:LIENS/my:LIEN_TYPE)

I need to display a count for each unique value

Example:

Below are the values in my table:

Building Loan Agreement
Lis Pendens
Building Loan Agreement
Building Loan Agreement
Lis Pendens
Mechanics Lien

It should display like the following:

Building Loan Agreement 3
Lis Pendens 2
Mechanics Lien 1

Currently I am able to display the list of unique values but I am not able to get a count on each

Please help