We have about 12 custom fields that represent quotes from suppliers for a contact’s project. We would like to use a math function to find the lowest value in the custom fields and then multiply that value to a known quantity in order to get a projected cost.
Does anyone know of any third party math plugins? We have tried theapiguys http: “FieldMath” api tool but it does not appear to use the min(a,b,c) formula.
a = ~Contact._field1~ = 2
b = ~Contact._field2~ = 2.5
c = ~Contact._field3~ = 2.7
~Contact._LowestBid~= min(a,b,c) = 2