I have a user who has requested a way to track vendors and their price quotes for project work. The user would like to have the list automatically calculate the total of all quotes listed. There can be an unknown number of vendors for each project, potentially upwards of 10 in some cases. One solution I'm considering is as follows:
Allow the user to format the vendors and quotes into a single line of text column using a naming convention "VENDOR - $12345678;" and use a calculated column (or some other solution) to parse out the values, convert them to numbers, and calculate the solution.
An example might look like this:
Vendor1 - $10000; Vendor2 - $73200; etc...
Thoughts? I also have access to InfoPath 2013. I'm just not sure where to go without generating a large number of columns and, as always, OOTB solutions are preferred for simplicity of long-term support.