Skip to main content
Nintex Community Menu Bar

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!

Hello Chris,

I tried your requirement on my site, and here are the steps:

Workflow Variables: ColResult (collection type), Result (Number type with default value 0), Sum (Number type with default value 0)

1) Use regular expression action to Split the data. Pattern is ; and Input is the SP column where your 170; 30 values were stored.

Store results in ColResult.

2) Foreach action to loop through the ColResult and store result in Result

3) Math operation to sum the values: ColResult and Sum; store the result in Sum variable

Once looping is completed, you will get the added value in the Sum variable.

Worked perfectly! Thanks so much, Soni!

Reply


Sidebar Buttons
Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
Terms & ConditionsCookie settings