Hi All,
I have data like
EmpID Salary Paid Date Salary Paid
100 627.8 1/11/2019
100 1085.56 1/25/2019
100 1055.01 2/8/2019
100 980.6 2/22/2019
100 653.35 3/8/2019
100 870.94 3/22/2019
100 385.2 4/18/2019
101 2032 1/4/2019
101 3466 1/18/2019
101 2652 2/1/2019
101 2013 4/26/2019
Is there any way identify a "Trend Decreasing" flag (Yes/ No). only one record or preferably decision on "Decreasing" can be repeat for all the rows. something like
EmpID Salary Paid Date Salary Paid Decreasing Flag
100 628 1/11/2019 Y
100 1086 1/25/2019 Y
100 1055 2/8/2019 Y
100 981 2/22/2019 Y
100 653 3/8/2019 Y
100 871 3/22/2019 Y
100 385 4/18/2019 Y
101 2032 1/4/2019 N
101 3466 1/18/2019 N
101 2652 2/1/2019 N
101 2013 4/26/2019 N
Y/N is the valued for each empid (not for each row)
Thanks
I have data like
EmpID Salary Paid Date Salary Paid
100 627.8 1/11/2019
100 1085.56 1/25/2019
100 1055.01 2/8/2019
100 980.6 2/22/2019
100 653.35 3/8/2019
100 870.94 3/22/2019
100 385.2 4/18/2019
101 2032 1/4/2019
101 3466 1/18/2019
101 2652 2/1/2019
101 2013 4/26/2019
Is there any way identify a "Trend Decreasing" flag (Yes/ No). only one record or preferably decision on "Decreasing" can be repeat for all the rows. something like
EmpID Salary Paid Date Salary Paid Decreasing Flag
100 628 1/11/2019 Y
100 1086 1/25/2019 Y
100 1055 2/8/2019 Y
100 981 2/22/2019 Y
100 653 3/8/2019 Y
100 871 3/22/2019 Y
100 385 4/18/2019 Y
101 2032 1/4/2019 N
101 3466 1/18/2019 N
101 2652 2/1/2019 N
101 2013 4/26/2019 N
Y/N is the valued for each empid (not for each row)
Thanks