Hi,
Â
I have a look up field with multiple selections. The selections are stored in a array. I want to do a lookup for this array values in a list and get their amounts.
Eg: Lookup will select product IDs in a array 444,555,666] in a calculated column.
I want to do a lookup on the above array to replace them with amount. eg $300,$400,$500] and get a sum, is that even possible?
If I do lookup, it brings back value of only the first item in the arrayy$300].