Forum Discussion
Dividing categorical columns
I have two columns - one with the selected vendor for each project and one for the shortlisted vendors for each project. How do I get a winning percentage per vendor that shows how many of the proje...
Here is some dummy data.
Because the shortlisted vendors are in one field, I have split the cell into rows, which gives several selected vendor rows for each project.
In this case the output for vendor 2 should be 66.67%, as they won 2 projects and were invited 3 times.
v-kelly-msft
Community Support
Community SupportHi Anonymous ，
According to your sample data,why the invited times for vendor 2 is 3 times not 2 times?Why for project CDATA0003,vendor 2 is not selected,but in the shorlisted vendor?
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!