Forum Discussion

JVonnahmeJVonna's avatar
JVonnahmeJVonna
Qrew Trainee
6 years ago

Is there a way to get a value based on comparing 3 different fields across all records and then combining the results for a total ranking?

For each record, I have a field for the bottle weight, closure weight, and label weight. I was wondering if there was a way to have each field compared to all the other record's corresponding field to determine it's ranking, then to be able to combine analyzing those rankings to give the bottle an overall ranking. I was able to achieve something like this on excel with multiple formulas, but do not know how I can convert it to QuickBase.
App builders
Formulas and functions
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    For a native solution to rank on just one attribute at a time, you can use a summary report in a particular way.  The results will be visible, but will not give a field on the record.

    So what you do is to create a formula numeric field called

    [Ranking]

    with a formula of 1

    Then make a Summary Report type to Group Rows by Item, and sort the report on the weight.  Then include the field ranking but set that field to use totals running down the page.

    Once you make that report, then you will need to make two more reports to sort on he other two attributes.