Error: given key not present in dictionary

[SKETCHwade]

Hi,

This is my expression:

IF([How many more machines?] = >1, ANY(SELECT(Pre Start[Equipment],MAX(Pre Start[_ROWNUMBER])=[_ROWNUMBER]-1)),"")

If I break it down to:

ANY(SELECT(Pre Start[Equipment],MAX(Pre Start[_ROWNUMBER])=[_ROWNUMBER]-1))

It works.
The error being:

Expression ‘EXPRESSION HERE’ could not be parsed due to exception: The given key was not present in the dictionary…

Now I am trying to understand what the error is referring to.
The column mentioned in the beginning of the if statement is a number column, an initial value of 0, and a max count of 2. I believe the issue may be that it is not shown unless another column is marked as True.

Any help is appreciated!

[WillowMobileSys · Accepted solution]

The “Greater Than Or Equal” operator should be inserted as “>=” , no spaces and order does matter.

[SKETCHwade]

Wow, my mistake, Its been a while since I wrote an expression and didnt realise the equal sign was not required haha

[WillowMobileSys]

SKETCHwade:

the equal sign was not required

Oh, so really meant “Greater Than” 1. Got it!