Calculate minimum formula

[Renato_Alves]

Hi,

I am new to Retool, and I am trying to build a basic formula for retool. Basically, I have this formula in excel: =min(MOU, Property value)*LTV.

I want to know how can I calculate the minimum value using two fields.

[dcartlidge]

Hi, welcome to the community.
The javascript Math library has a min function that accepts any arguments or array of values, eg
Math.min(8,5,4,6,9) would return 4
You could pass in the properties to this function that you want to compare

[Renato_Alves]

@dcartlidge

Math.min

It should be?

{{math.min (slider5.value, slider6.value) * currency5.value}}

[dcartlidge]

Uppercase M on Math

[Renato_Alves]

@Renato_Alves

{{math.min (slider5.value, slider6.value) * currency5.value}}

It worked! Thank you a lot!