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