topic Re: Flaging the values in table in App Development

Flaging the values in table

dhanu_today — Thu, 11 Nov 2021 17:35:22 GMT

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 — Thu, 11 Nov 2021 17:36:46 GMT

Attached the data in excel.

TIA

Dhanu

MayilVahanan — Fri, 12 Nov 2021 02:46:39 GMT

Try like below

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

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

o/p:

MayilVahanan — Fri, 12 Nov 2021 02:47:10 GMT

Here Column(1) indicates ur first expression

dhanu_today — Fri, 12 Nov 2021 04:43:52 GMT

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