Dynamic Variable Value Assignment

[EnglishManBob]

I think this cam be done with Dynamic Replace; however I am unsure of how to do so:

I have a table of yearly quarters.  If all of the quarters have values I would like the full calendar to have a value (calculated elsewhere).  If any of the quarters associated with that calendar year are NULL I would like the calendar year cell to be NULL.  The intended output should create ongoing values over time.

That is if the full quarterly data for 2021, 2022, 2023...  etc. is not available (in other words NULL) CY2021, CY2022, CY2023 should be NULL.  If data from all quarters for 2021, 2022, 2023 are available the values for CY2021, CY2022, CY2023 should be available.

Example 2021 (partial data available)

2021 Q1	2021 Q2	2021 Q3	2021 Q4	2021 CY
5	7	NULL	NULL	NULL

Example 2021 (partial data available)

2021 Q1	2021 Q2	2021 Q3	2021 Q4	2021 CY
5	7	1	NULL	NULL

Example 2022 (full data available)

2021 Q1	2021 Q2	2021 Q3	2021 Q4	2021 CY
5	7	1	3	16

[Qiu]

@EnglishManBob 
I feel i am a bit over doing it. just want to be dynamic.
And I have hard time of picturing your input data format.