Volume 4 InfoPath Sum total X value is used in a drop down. By EricHarlan Published: September 9, 2007 Volume 4 InfoPath and Moss. See how to get the count, or number of times a value is selected in an InfoPath drop down menu. Usually drop down menus will only be bound to one data source element, therefore it is tricky to get how many times a specific value in that drop down is used. The below tutorial will show you how.

For reference, below is the function expression you can copy and use.

Red = The xpath to the data source

Green = The exact data source name you want to reference

Blue = Value you want to get the count on

count(/my:Schema/my:UEPP/my:LCODES/my:Partial_hand_functional[my:Partial_hand_restoration_txt = 'L6000'])