Text to column in a formula, 1+2+1 (sum)

[RAS-KQ]

Hello,

I'm stuck at a problem, can't figure it out...

I have a list of values seperated with a string (result from a cross tab), looks like this:

I would like to sum the values in the input column using a formula.

There are 20 more columns like this, so probably a multi field formula, but how?

[Aidan_K]

Hi @RAS-KQ

will your input field always have 3 records ?

i.e. 3 numbers = 0+0+1

[Aidan_K]

assuming the answer to previous question is yes you could parse the data (using + as delimiter), add new fields together and finally select the fields you want to keep (i.e. "Input" & "Output")

See example attached

[jdunkerley79 · Accepted solution]

If you want to create a workflow which can decode any formula then you can do this using a batch macro.

The attached creates a simple evaluation of each row.

There is a more fully featured macro included in the CReW macros

[RAS-KQ]

Yes, that's it. Thank you both.

I forgot macros can be used like that.

D'oh!