InfoPath Dev

 Help!  I am trying to create a company expense report and I can't figure out how to format a formula for the "Due Employee" cell! I need to total the "Cost" field to sum in the "Due Employee" field only if the "Pmt Method" field is PCC or CASH, does that make sense?

Thank you in advance for all of your help!! 

The image you added seems to be broken, but I think a formula like this should do the trick:

    sum(repeatingRow[my:pmtMethod = "PCC" or my:pmtMethod = "CASH"]/my:cost)

I hope this one goes through!

If the example image were an actual report, I would need the "Due Employee" field to read 10

The formula provided earlier did not work, the names of the fields are as follows;

Pmt_Method (options in dropdown are BCC, PCC, CASH)

Amount (cell under cost)

 Perhaps this image works better?

Yes, the formula in the previous post was just an example because I didn't know the actual field names.  Now that I do, I believe the formula would be:

sum(/my:myFields/my:Itemized_Expenses/my:Receipt_Description[my:Pmt_Method = "PCC" or my:Pmt_Method = "CASH"]/my:Amount)

 YES!!! THANK YOU!!!