Solved: Switch query - Page 2

JamesWB · 04-01-2022 07:11 AM

I want to evaluate possible values of a field, "Edit_count", which is of type ChangeCounter. Based on those, I then change the value or don't change it, of another field.

I am trying a switch statement like this, but it throws the error "sequence contains no elements". Where am I going wrong?

SWITCH([Edit_count], < 1, COUNT(FILTER("Hazard", [Machine] = [_THISROW].[Machine])) + 1, 1, COUNT(FILTER("Hazard", [Machine] = [_THISROW].[Machine])) + 0, > 1, COUNT(FILTER("Hazard", [Machine] = [_THISROW].[Machine])) + 0)

Suvrutt_Gurjar

It is difficult to opine without knowing more details, but it sounds your entire expression should be as follows

IFS(

[Edit_count] <=1 ,COUNT(FILTER("Hazard", [Machine] = [_THISROW].[Machine])) + 1,
[Edit_count] > 1 , COUNT(FILTER("Hazard", [Machine] = [_THISROW].[Machine])) + 0

)

I think your expression was not throwing error based on first part of the expression which seemed to be syntactically correct and I think remaining expression was ignored by the editor.

IFS(([Edit_count] <1) ,COUNT(FILTER("Hazard", [Machine] = [_THISROW].[Machine])) + 1)
([Edit_count] = 1) , COUNT(FILTER("Hazard", [Machine] = [_THISROW].[Machine])) + 1
([Edit_count] > 1) , COUNT(FILTER("Hazard", [Machine] = [_THISROW].[Machine])) + 0

View solution in original post