### Title

help with script to total amounts based on multiple fields

### Post

Okay here is thge info and I'm really confused in trying to make this happen.

this is where I am at with this

FOR THE PRIME

If (eval::prime_gender="F" AND eval::prime_cert="udbe" AND eval::prime_ethn="asian"; prime_amount)

FOR THE SUB

if (dbe::ethn="asian" AND dbe::gender="F";bid_quote)

------------------------

I want to add these together and if one does not meet the criteria and the other does I still want the dollar amount from the one that met the criteria.

appreciate any help

If (eval::prime_gender="F" AND eval::prime_cert="udbe" AND eval::prime_ethn="asian"; prime_amount) + if (dbe::ethn="asian" AND dbe::gender="F";bid_quote)

Adds them together (If these are defined in different calculation fields, you can just add the fields). If only one is valid, you'll get only that amount returned as the other result will be null.

That all seems too easy though. Is there something I missed or didn't understand?