I'm trying to write a formula that will total up how many times each different item appears on a report. Lets say I have a data field that is two characters long and has the items "MU", "PU", and "LU" in it. How would I got about writing a formula that would count each time each one appeared and total it for each seperate item?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Counting different data item in a field? 1
- Thread starter Laurelin
- Start date
-
1
- #2
I would suggest using a running total for each of the conditions/outcomes
Summary type being a Count.
Use a formula to evalutate.
{field}="MU"
Reset whenever (if) you want. If you find the postings here in the Tek-Tips Forum helpful, please let us know by using the "Click here" option. (you don't have to be the poster) It's painless and lets us know our help has been useful and is appreciated.
Mike
Summary type being a Count.
Use a formula to evalutate.
{field}="MU"
Reset whenever (if) you want. If you find the postings here in the Tek-Tips Forum helpful, please let us know by using the "Click here" option. (you don't have to be the poster) It's painless and lets us know our help has been useful and is appreciated.
Mike
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question