Bonus based on two variables into a table

[MarcoBigio]

Hello everyone, I am trying to calculate bonuses for employees based on unit sales and gross profit achievement compared to the forecasted sales and gross profit.

I am unsure of how to go about this while avoiding a terribly long if statement in the formula tool. I have both the forecasted and achieved values for the gross profit and the unit sales as an input into the table with store name, forecasted gross profit, forecasted unit sales, actual gross profit, and actual sales as column headers.

Attached is a screenshot of the table that we currently use to calculate bonuses manually in excel. If anyone knows how to go about calculating this in Alteryx, any help would be appreciated! 

[mattnason1 · Accepted solution]

I'd do something like this.  Although I might be missing what you're trying to do.

[Qiu]

@MarcoBigio 
We can use transpose tool to change your Excel look table to a index then append your store input.

[MarcoBigio]

Thank you so much!!