Skip to main content
Question

Remove minimum from a group of numbers

  • November 15, 2019
  • 0 replies
  • 24 views
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 except for the lowest/smallest value.
So if the first 3 fields have the values 5, 1,  7 I need it to give me the response of 12.  

Is there a way I can calculate this field

------------------------------
Mike Klausing
------------------------------
This topic has been closed for replies.

AdamKeever1
Forum|alt.badge.img+2
Try

Sum ( [field1], ..., [field10]) - Min( [field1], ..., [field10])

------------------------------
Adam Keever
------------------------------
MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
AdamKeever1
Forum|alt.badge.img+2
---removed post---
------------------------------
Adam Keever
------------------------------
AdamKeever1
Forum|alt.badge.img+2
Try this Mike:

Sum([Field1],[Field2],[Field3],[Field4])-

Min(If([Field1]>0,[Field1],null),
If([Field2]>0,[Field2],null),
If([Field3]>0,[Field3],null),
If([Field4]>0,[Field4],null))​


Here is what it returns; works with blanks too:


------------------------------
Adam Keever
------------------------------
Terms & ConditionsAccessibility statement