Solved: Which expression is best to use in this example - Page 2

Gardener76 · 07-28-2020 11:36 AM

Hi

I have an app that monitors swimmers who are either in or out of the pool. Each swimmer will enter and exit the pool twice. So I have the following columns:

[Start] Initial value of 00:00.

[Swim Exit 1] Initial value of 00:00.

[Swim Entry 2] Initial value of 00:00.

[Finish] Initial value of 00:00.

[Swim Status]

What expression would I use in column [Swim Status] to show whether the swimmer is “IN” or “OUT” of the pool?

TIA your expertise is much appreciated.

Steve

Missing comma. Try:

IFS(	
	OR(
		NOT([_THISROW_BEFORE].[START] = [_THISROW_AFTER].[START]),
		NOT([_THISROW_BEFORE].[SWIM ENTRY 2] = [_THISROW_AFTER].[SWIM ENTRY 2])
		
	),"IN",
	OR(
		NOT([_THISROW_BEFORE].[SWIM EXIT 1] = [_THISROW_AFTER].[SWIM EXIT 1]),
		NOT([_THISROW_BEFORE].[FINISH] = [_THISROW_AFTER].[FINISH])
	),"OUT"
)

View solution in original post