Flaging the values in table

[dhanu_today]

HI Team,

I hope everyone is doing good.

I have the data like below and expected result in Expression2.

Empid	Name	Manager	Expression1 Logic	Expression1 Result	New Expression Logic	New Expression
1	Ajay	Peter	count({<load_date_Test2={"$(=Max(load_date_Test2))"}>} distinct Empid) - Count({<load_date_Test2={"$(=monthend(addmonths(max(load_date_Test2),-1)))"}>} distinct Empid)	1	1)If Empid is more than 1 time (e.g 1 and 4) then we need to show as Change, 2) if empid is having only one time and Expression1 value 1 then In 3)if empid is having only one time and Expression1 value -1 then Out	Change
1	Ajay	James		-1		Change
2	Martin	Peter		1		In
3	Kevin	Rocky		-1		Out
4	Lin	Thomson		1		Change
4	Lin	Edward		-1		Change
5	Melsis	Thomson		1		In
6	Jocky	Edward		-1		Out

[dhanu_today]

Attached the data in excel.

TIA

Dhanu

[MayilVahanan]

Hi

Try like below

if(Count(Total<Empid> Empid) > 1, 'Change',

If(Column(1) = 1, 'In', 'Out')
)

o/p:

[MayilVahanan]

Here Column(1) indicates ur first expression

[dhanu_today]

Thanks Mayil for your help.

I applied the formula but its giving wrong result at expression 1.

Requirement like: Need to identify who is new emp to date and who left and who changed the manager.

Expression 1 : Logic

count({<load_date_Test2={"$(=Max(load_date_Test2))"}>} distinct Empid)
-

Count({<load_date_Test2={"$(=monthend(addmonths(max(load_date_Test2),-1)))"}>}
distinct Empid)

Here attaching my sample data.

TIA

Dhanu