I would like to set up a score field that is calculated based on the values of other fields.
The other fields could include different values and each value has a score. I would like to take the max of these scores and multiply them by each other.
Field 1 * field 2 * field 3
The weight of each value is predefined.
Can this be achieved?