need help with a field for total of $ based off a text field in a portal
I have a field that I use as a marker to determine if another field meets a certain criteria. Example if the owner of a company is a man and is Hispanic the field shows the text "DBE". If the owner is a female and Hispanic it shows UDBE. I placed this marker field in a portal that show records from a related table. I have also placed a field from the current table in the portal "cost". I used this field to place the amount charged by the business.
What I need is to make a field that I can use to total the amounts from the "cost" field for every business that is a "DBE". Help please.....