Something like Excel's "Solver" - to find adjustment coefficient for market share

[egor_gazarov]

Dear friends, could you please help me with the following. Let's suppose I have a table with:

• Total market size by regions
• Market share of our company, that we get from market agency

Regions	Market size	Reported Market Share
Region A	1,400	8%
Region B	1,500	14%
Region C	1,800	7%
Region D	700	10%

But I also know that market share are not precise enough. Because total real market share in the country (that consists out of this 4 regions) is 12%. And if we do the math in table above, it will return us 9.6%.

In Excel I would make a cell called "Adjustment coefficient", make a new column "Adjusted market share" (reported MS multiploed by the adjustment coeffecient) and run solver to tell me, that if market share in each region is proportionally increase by 1.2510, our total market share in country will match.

But what is the best way to do it in Alteryx?

My goal is to get result like this:

Regions	Market size	Reported Market Share	Ajusted Market Share
Region A	1,400	8%	10%
Region B	1,500	14%	18%
Region C	1,800	7%	9%
Region D	700	10%	13%

[JohnJPS · Accepted solution]

If I'm understanding this correctly, I can think of a couple approaches in Alteryx.

• Add a workflow constant "Adjustment coefficient" and then multiply each row (using Formula tool) by that coefficient
• Use the formula tool to add a new column "Adjustment Coefficient and assign it a constant value; then another column that multiplies by this value.

I've attached a workflow that does it each way.  Hope that helps!