How to compare current week monday value with previous week monday value ? If there's difference in both it should display the value.

userpd_2021 — Thu, 24 Feb 2022 11:35:57 GMT

The sample table is : In the below table I want to compare the current week number to the previous week number to check if the values are different. In case 1 (112) current week is 2022/04 and previous week is 2022/03 which has null value in the output table both this value is to be displayed .

Note current week value is according to weekstart today and previous is weekstart today-1.

P Id	P Desc	P Prod	Cycle No	Week No	Value
112	asm	222	178	2022/2	PD
112	asm	222	178	2022/4	PD
123	abc	222	178	2022/1	X
123	abc	222	178	2022/2	X
123	abc	222	178	2022/3	X
123	abc	222	178	2022/4	X
131	hah	222	178	2022/1	PD
131	hah	222	178	2022/2	PD
131	hah	222	178	2022/3	PD
131	hah	222	178	2022/4	X
132	bvs	222	178	2022/1	X
132	bvs	222	178	2022/2	X
132	bvs	222	178	2022/3	X
132	bvs	222	178	2022/4	X

Please find the output table. It should only contain data for current and previous week.

Output
P Id	P Desc	P Prod	Cycle No	Week No	Value
112	asm	222	178	2022/3
112	asm	222	178	2022/4	PD
131	hah	222	178	2022/3	PD
131	hah	222	178	2022/4	X

How can I achieve this?

topic How to compare current week monday value with previous week monday value ? If there's difference in both it should display the value. in App Development

How to compare current week monday value with previous week monday value ? If there's difference in both it should display the value.