getting the total number of times a value is chose in a drop down

[ste.agile]

Hi All

I've created an infopath form to help calculate wages in our business.

I have a drop down box for each day of the month, for each employee with
options such as At work, on holiday, sick etc.

What I want infopath to do is count all the occasions that the different
options are picked. i.e. if the form showed an employee having 3 days holiday
I want infopath to collect this so that later on in the form I can multiply
the number of holidays taken by the employees daily rate to work out how much
holiday pay the employee is owed for that month.

Its so easy in excel but trying to do it in infopath is driving me crazy!!
If anyone could help I would really appreciate it.

 

[Ed Thurber]

it will look something like this

count(my:field[my:element="some Value"])

the values in the [] are a WHERE clause.

the "my:field" need to be a repeating node.