I think I'm making something harder than it should be... but here goes.
I have the following five fields:
@White
@Red
@Yellow
@Green
@Blue
Each field has a formula and the resulting numeric values will be:
@White 1 if true 0 if false
@Red 2 if true 0 if false
@Yellow 3 if true 0 if false
@Green 4 if true 0 if false
@Blue 5 if true 0 if false
Each row contains each of the 5 fields. Results can vary from record to record... meaning you can get any combo of numbers.
I want to find the maximum value among the 5 fields.
So if for instance the resulting values in a row are 1 0 3 4 0, I want the find the max (4)
Make sense? Thanks for the help.
I have the following five fields:
@White
@Red
@Yellow
@Green
@Blue
Each field has a formula and the resulting numeric values will be:
@White 1 if true 0 if false
@Red 2 if true 0 if false
@Yellow 3 if true 0 if false
@Green 4 if true 0 if false
@Blue 5 if true 0 if false
Each row contains each of the 5 fields. Results can vary from record to record... meaning you can get any combo of numbers.
I want to find the maximum value among the 5 fields.
So if for instance the resulting values in a row are 1 0 3 4 0, I want the find the max (4)
Make sense? Thanks for the help.