Here is the formula I used:
([Total Kicker Count (1-10)]*[Kicker - Total]) -Min(If([Kicker cost 1st]>0,[Kicker cost 1st],0),
If([Kicker Cost 2nd]>0,[Kicker Cost 2nd],0),
If([Kicker Cost 3rd]>0,[Kicker Cost 3rd],0),
If([Kicker Cost 4th]>0,[Kicker Cost 4th],0),
If([Kicker Cost 5th]>0,[Kicker Cost 5th],0),
If([Kicker Cost 6th]>0,[Kicker Cost 6th],0),
If([Kicker Cost 7th]>0,[Kicker Cost 7th],0),
If([Kicker Cost 8th]>0,[Kicker Cost 8th],0),
If([Kicker Cost 9th]>0,[Kicker Cost 9th],0),
If([Kicker Cost 10th]>0,[Kicker Cost 10th],0))
This still gives me the full cost and isnt subtracting the minimum cost
------------------------------
Mike Klausing
------------------------------
Original Message:
Sent: 11-19-2019 09:57
From: Adam Keever
Subject: Remove minimum from a group of numbers
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
Original Message:
Sent: 11-15-2019 15:29
From: Mike Klausing
Subject: 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 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
------------------------------