Help

Formula help for Star Rating Fields

Topic Labels: Formulas
913 1
cancel
Showing results for 
Search instead for 
Did you mean: 
DCxp
4 - Data Explorer
4 - Data Explorer

I have 10 fields with star ratings, is it possible for me to list the top 3 star rated fields in  different field? 

1 Reply 1

Yeah, you would need to:
1. Create a new table called "Summary" or some such that had a single record
2. Create a new record in it with the primary field value of "Rollup" or something
3. Link all your existing records from your original table to that one record
4. Create rollup fields in your "Summary" field to sum up the star value of each field
5. Create a formula field that will output the name of the top 3 fields