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!
Solved! Go to Solution.
The โGreater Than Or Equalโ operator should be inserted as โ>=โ , no spaces and order does matter.
The โGreater Than Or Equalโ operator should be inserted as โ>=โ , no spaces and order does matter.
Wow, my mistake, Its been a while since I wrote an expression and didnt realise the equal sign was not required haha
Oh, so really meant โGreater Thanโ 1. Got it!
User | Count |
---|---|
42 | |
29 | |
25 | |
23 | |
13 |