Recalc measure

Hi,

Our business needs a adjustment metric which is basically difference between two percentage measures.

Following is the screenshot of the metrics and the relationship.

       

READ	WRITE	WRITE	READ	READ
Gross Dmd MD POS R	Gross Dmd MD POS R%	Gross Dmd MD POS R% to MD POS R% Adj	MD POS R	MD POS %
40,163	75.00%	-1.91%	30,888	76.91%
34,020	60.00%	-1.42%	26,117	61.42%
26,775	50.00%	-2.00%	20,885	52.00%
45,045	65.00%	-0.37%	33,976	65.37%
57,330	70.00%	-1.40%	43,854	71.40%
203,333	64.55%	-1.56%	155,721	65.91%

Here user enters the value for Gross Dmd MD POS R % (recalc), resulting in calculation of Gross Dmd MD POS R (Gross Dmd MD POS R/Gross Dmd R)

Now the next rule is (with 2 expressions)

MD POS R % = Gross DMD MD POS R % - Gross Dmd MD POS R % to MD POS R % Adj