In Stock Row Percentage

[BrianHausman]

Hi, I am new to the tool and trying to find a way to get a total % of in stock items by location.  My data would look something like this-

Plant Name	SKU Number	SKU Name	Qty EA
St Louis	111111	String	5
St Louis	111112	Bow	4
St Louis	111113	Arrow	9
St Louis	111114	Glove	0
St Louis	111115	Strap	6
Chicago	111111	String	2
Chicago	111112	Bow	1
Chicago	111113	Arrow	6
Chicago	111114	Glove	0
Chicago	111115	Strap	0
Kansas City	111111	String	0
Kansas City	111112	Bow	1
Kansas City	111113	Arrow	4
Kansas City	111114	Glove	4
Kansas City	111115	Strap	0

And I would like to roll the results in to something like this representing the total percentage of items that have stock.  Even if there are only one in stock I would count it as in stock.

St Louis	80%
Chicago	60%
Kansas City	60%

Any help would be appreciated.  Thanks

[atcodedog05 · Accepted solution]

Hi @BrianHausman 

Here is how you can do it.

Workflow:

Hope this helps : )

[BrianHausman]

That worked perfectly, thank you so much.

[atcodedog05]

Happy to help : ) @BrianHausman 

Cheers and have a nice day!