I have a list that looks up for information from other lists. There is a basic column (single line of text) showing quantity and an other one showing the price (lookup). The only thing I'd like to achieve is to be able multiplying those 2 numbers. SharePoint does not allow to calculate with lookup item so the easiest way does not work. I was trying to create a workflow but it only lets me to copy list item to an other list, but not to a given column in that list. Note: SPD is enabled.
Do you have any solution for that?