[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.
Solved! Go to Solution.
So change 1 to 1.0.
So change 1 to 1.0.
Ah! Thanks!
User | Count |
---|---|
28 | |
27 | |
22 | |
22 | |
22 |