Can I use MIN() with type - decimal to find the lowest decimal/number in a column?
Solved! Go to Solution.
Then just put the MIN expression in a virtual column somewhere.
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.
Thanks,
I am not seeing how to run the expression. It gives me this error:
The problem is that the column is not expecting a Decimal value. Check the column type.
Here is that table I am using to get this expression:
Where did you enter the expression?
As a slice. Is that not correct?
It is not correct. What are you trying to do?
I want to show the lowest DSO (decimal) in the column. I can show this as a detail view or table
The slice condition needs to be an equality that returns as true if a record's value matches the MIN().
Oh. I don't want that. I just want to show the lowest value in that column?
Then just put the MIN expression in a virtual column somewhere.
User | Count |
---|---|
42 | |
25 | |
25 | |
17 | |
13 |