InfoPath Dev

Jimmy, Imagine the entire Internet giving you a standing ovation right now, It worked! Thank you, Oren

 Hi Yes, there are many MA values which are the same, The requirement is to count only those unique MA records.    

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

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 != ...

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

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

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 ...