6 Replies Latest reply on Oct 5, 2010 1:24 PM by philmodjunk

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

    kilbot

      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