AnsweredAssumed Answered

need help with a field for total of $ based off a text field in a portal

Question asked by kilbot on Oct 4, 2010
Latest reply on Oct 5, 2010 by philmodjunk

Title

need help with a field for total of $ based off a text field in a portal

Post

Okay,

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

Thanks

Outcomes