LIST has elements of mismatched types - REALLY??

[RedVox]

[Rank] is a decimal column.  As a formula to update the value of [Rank], this works:

Max(Select(Food Orders[Rank], ([Rank] < [_THISROW].[Rank]), False)) - 0.001

But, if I want to compare that numeric value to another, this returns an error:

Min(List(Max(Select(Food Orders[Rank], ([Rank] < [_THISROW].[Rank]), False)) - 0.001, 1))

I don't understand why if the first formula is okay, why adding it to a list that includes a number doesn't work.  They both seem like numbers to me.  

[Steve · Accepted solution]

So change 1 to 1.0.

[RedVox]

Ah!  Thanks!