General

Re: "if" equals "fielda or fieldb" sum "fieldc"

kseger — Tue, 08 Jan 2013 18:01:57 GMT

YES!!! THANK YOU!!!

Re: "if" equals "fielda or fieldb" sum "fieldc"

Jimmy — Tue, 08 Jan 2013 17:56:02 GMT

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)

Re: "if" equals "fielda or fieldb" sum "fieldc"

kseger — Tue, 08 Jan 2013 17:46:05 GMT

Perhaps this image works better?

Re: "if" equals "fielda or fieldb" sum "fieldc"

kseger — Tue, 08 Jan 2013 15:50:54 GMT

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)

Re: "if" equals "fielda or fieldb" sum "fieldc"

Jimmy — Tue, 08 Jan 2013 04:29:50 GMT

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)

"if" equals "fielda or fieldb" sum "fieldc"

kseger — Mon, 07 Jan 2013 23:05:26 GMT

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