% field, based on a count field

  • Thread starter Thread starter elektra
  • Start date Start date
E

elektra

Guest
I have a field that tells whether a customer was a buyer or seller of a particular product. The field is named "BuyerSeller". I have a form that displays records of sales/buys for a particular time range. This form includes all kinds of calculated fields. But I'm having trouble with the "BuyerSeller" field. First, I need a field that simply totals the number of records that have "Seller" selected in the "BuyerSeller" field. Then I need another form field that gives me the percentage of records represented by the seller, ie.

total#of"sellers"/total records returned

I imagine this second field will be easy, once I figure out how to get the first one, which counts how many are "sellers". I hope this makes sense!
 

Users who are viewing this thread

Back
Top Bottom