Remove minimum from a group of numbers
I have 10 formula numeric Fields being calculated into number [total kicker cost]. Kicker Quantity 1st, Kicker Quantity 2nd...Kicker Quantity 10th I need to add up all of these fields together ex...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendhow about
Sum([field 1], [field 2],...[field 10])
-
Min(([field 1], [field 2],...[field 10])
but what if there is only one or two values??
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Sum([field 1], [field 2],...[field 10])
-
Min(([field 1], [field 2],...[field 10])
but what if there is only one or two values??
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
That formula should work except in the case where fields 8, 9, and 10 etc are blank or zero. I need to have something that subtracts the Min of those values 1-10 that are also greater than 0
Thank you,
Mike Klausing
------Original Message------
how about
Sum([field 1], [field 2],...[field 10])
-
Min(([field 1], [field 2],...[field 10])
but what if there is only one or two values??
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
