How to get same value as above row

[Anonymous]

Hi all,

Below i have 2 data of order (10000776769 & 10000589016).  How can I get all actual date row follow the same date as ZN01 date.

Current Actual date formula: if AFVC="ZN01" then Date else 0

Order	AFVC	Value	Date	Actual Date
10000776769	ZN01	0	5/6/2023	5/6/2023
10000776769	ZN02	0	7/6/2023	0
10000776769	ZN03	0	7/6/2023	0
10000776769	ZN04	3	7/6/2023	0
10000776769	ZN05	56	7/6/2023	0
10000776769	ZN06	0	7/6/2023	0
10000776769	ZN07	0	7/6/2023	0
10000776769	ZN08	0	7/6/2023	0
10000776769	ZN09	0	7/6/2023	0
10000776769	ZN10	78	7/6/2023	0
10000776769	ZN11	1	7/6/2023	0
10000776769	ZN12	0	7/6/2023	0
10000776769	ZN13	0	7/6/2023	0
10000589016	ZN01	0	2/6/2023	2/6/2023
10000589016	ZN02	0	3/6/2023	0
10000589016	ZN03	0	3/6/2023	0
10000589016	ZN04	0	3/6/2023	0
10000589016	ZN05	2	3/6/2023	0
10000589016	ZN06	0	3/6/2023	0
10000589016	ZN07	0	3/6/2023	0
10000589016	ZN08	29	3/6/2023	0
10000589016	ZN09	1	3/6/2023	0
10000589016	ZN10	66	3/6/2023	0
10000589016	ZN11	0	3/6/2023	0
10000589016	ZN12	0	3/6/2023	0
10000589016	ZN13	0	3/6/2023	0

Regards,

Nuha

[m_dekorte]

Hi @Anonymous,

If you want to repeat the same "Actual date" for the other order records, use null instead of 0 in your conditional column and subsequently select the fill down option. Note that this requires there has to be an AFVC="ZN01" for each order in your table.

[Anonymous]

hI @m_dekorte , 

I dont think your solution will solve my issue here. I do change the value 0 to NULL but I still stuck at this point. I want the value as below image aligned in each row (3 rows = 3 different date = 1 production order)

Regards,

Nuha

[m_dekorte]

Right click the column header/ Fill/ Down

[Anonymous]

Hi @m_dekorte ,

Already done the step but it not fulfill my requirement. This is because not all date are in sequence as below. 

Order	AFVC	Value	Date	Actual Date
10000776769	ZN05
10000776769	ZN02	0	7/6/2023	0
10000776769	ZN03	0	7/6/2023	0
10000776769	ZN04	3	7/6/2023	0
10000776769	ZN13	56	7/6/2023	0
10000776769	ZN06	0	7/6/2023	0
10000776769	ZN07	0	7/6/2023	0
10000776769	ZN08	0	7/6/2023	0
10000776769	ZN09	0	7/6/2023	0
10000776769	ZN10	78	7/6/2023	0
10000776769	ZN11	1	7/6/2023	0
10000776769	ZN12	0	7/6/2023	0
10000776769	ZN01	0	5/6/2023	5/6/2023
10000589016	ZN01	0	2/6/2023	2/6/2023
10000589016	ZN02	0	3/6/2023	0
10000589016	ZN03	0	3/6/2023	0
10000589016	ZN04	0	3/6/2023	0
10000589016	ZN05	2	3/6/2023	0
10000589016	ZN06	0	3/6/2023	0
10000589016	ZN07	0	3/6/2023	0
10000589016	ZN08	29	3/6/2023	0
10000589016	ZN09	1	3/6/2023	0
10000589016	ZN10	66	3/6/2023	0
10000589016	ZN11	0	3/6/2023	0
10000589016	ZN12	0	3/6/2023	0
10000589016	ZN13	0	3/6/2023	0