Dynamic linking 2 Variable based on user selection on a field

[VaishnaviC]

Hi All,

The below variable will change once the user selects 'Sales Office' and sets value in 'Insert Full Year %':

=if((count(#GetFieldSelections(#Sales_Office))>=1and
if(#GetFieldSelections ([Sales Office])='CA05',$(vFullYear_CA05),100))

The below variable changes once the selection and value is inserted in 'CA05':

=if(#GetFieldSelections ([Sales Office])='CA05',$(vMaterial1),100)

⭐Need Solution for:

This variable (CA05) should reflect the same value as in variable (Insert Full Year %) based on user changes according to selections made.

Eg.: 'CA05' should reflect 50 in input as shown in image instead of 40 once value is inserted in (Insert Full Year %).

The variables in the formula calculates the bottom table in the image.

Thanks in advance!