InfoPath Dev

I have a secondary source in Infopath 2007 filler form template, This source is from a Sharepoint list that contains many records. my requirement is to count unique records (text) in one of the columns. Example: Col a A A A B B D Should count 3. Searched all over the place but could not find a proper solution... Ideas? Thanks, Oren.

The general format would be this:

count(repeatingGroup[field != preceding-sibling::repeatingGroup/field])

Jimmy, Thank you for your swift reply! I'll test it Sunday first thing and report back, Cheers, Oren

Hi, The suggested method did not work. I'm getting an error that a "Node test" was expected. Also, since it is a secondary source, Infopath added this prefix to the Xpath: xdDocument:GetDom ("source name")/dfs:...... Are you able to help? Oren

Could you post the actual formula you wound up with?

Sure: I tried either: count(xdXDocument:GetDom("Meetings")/dfs:myFields/dfs:dataFields/dfs:meetings/@MA[. != preceding-sibling::xdXDocument:GetDom("Meetings")/dfs:myFields/dfs:dataFields/dfs:meetings/@MA]) Or: count(xdXDocument:GetDom("Meetings")/dfs:myFields/dfs:dataFields/dfs:meetings[@MA != preceding-sibling::xdXDocument:GetDom("Meetings")/dfs:myFields/dfs:dataFields/dfs:meetings/@MA]) Thank you

Please give this a try:

count(xdXDocument:GetDom("Meetings")/dfs:myFields/dfs:dataFields/dfs:meetings[@MA != preceding-sibling::dfs:meetings/@MA])

Hi,

This time there was no error, but the it counted all the records save for one, i.e there are 3206 records and the count was 3205.

Any ideas?

Cheers,

Oren

Is there any chance there were two records with the same MA value?

 Hi

Yes, there are many MA values which are the same,

The requirement is to count only those unique MA records.

 

 

I see a potential issue in the formula.  Please try this:

count(xdXDocument:GetDom("Meetings")/dfs:myFields/dfs:dataFields/dfs:meetings[not(@MA = preceding-sibling::dfs:meetings/@MA)])

Jimmy,

Imagine the entire Internet giving you a standing ovation right now,

It worked!

Thank you,

Oren