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?

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:

Cross Tab.JPG

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?

Expression

Accepted answers

jdunkerley79

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

DynamicFormulaDemo.yxzp

All comments

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

RAS-KQ output.yxmd

jdunkerley79

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

DynamicFormulaDemo.yxzp

RAS-KQ

Yes, that's it. Thank you both.

I forgot macros can be used like that.

D'oh!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703