Can I use MIN() with decimal type to find the lowest decimal/number in a column?

[Tiger1]

Can I use MIN() with type - decimal to find the lowest decimal/number in a column?

[TeeSee1]

MIN(LIST(0.98,0.66)) gives you 0.66.

You can go ahead and try it yourself to see if it gives you what you desire.

[Steve]

MIN() - AppSheet Help

[Tiger1]

Thanks,

  I am not seeing how to run the expression.  It gives me this error:

[Steve]

The problem is that the column is not expecting a Decimal value. Check the column type.

[Tiger1]

Here is that table I am using to get this expression:

[Steve]

Where did you enter the expression?

[Tiger1]

As a slice.  Is that not correct?

[Marc_Dillon]

It is not correct. What are you trying to do?

[Tiger1]

I want to show the lowest DSO (decimal) in the column.  I can show this as a detail view or table

[Marc_Dillon]

The slice condition needs to be an equality that returns as true if a record's value matches the MIN().

[Tiger1]

Oh.  I don't want that.  I just want to show the lowest value in that column?

[Marc_Dillon · Accepted solution]

Then just put the MIN expression in a virtual column somewhere.