AnsweredAssumed Answered

How to SUM semi-colon separated values in a single column returned from a lookup

Question asked by thecarpe on Mar 21, 2016
Latest reply on Mar 23, 2016 by

I have created a column that looks up from a list. It can return multiple checkbox values and one of the additionally included carry-over columns is numeric.  Context: Assembly A and Assembly N are selected. Their values from the 2016 part count column are 170 and 30 respectively.  The value placed in the primary column is "Assembly A; Assembly B". The additional carry over column has "170; 30". 


I would like to add the numbers separated by the semi-colon into a single calculated 200 value. I'm hoping that I can do this with an inline function. I've tried replace and I just can't seem to get the syntax right. Has anyone done anything similar and had luck with the inline function?  Essentially, it will store in a variable and populate a total part count column.  I just need some additional imaginations on this.  Thank you!