I have a list of orders and I need to calculate the total price from each order.
The order items are a lookup from another list(Items) containing the item price itself. On my order list I would like to create a workflow which based on the multiple items in the order(these being placed in a multichoise single line text field) loops through each item , collects the price from the lookup list(Items) and add it to the total. Can this be done within a workflow or do I have to redo my orderlist be based on a repeating section instead of a multivalue column?
Thanks Jesper Bergmann