Is there an option to calculate the automatic sum only for double type?

[jeongilyoon]

Please understand that I am posting questions on google translator
If there are many columns, it is difficult to calculate the total. Is there an option to add only the columns of double type?

[ivoller]

Hi,

You can restrict the fields flowing through by using the Dynamic Select tool and choosing a type of Double. If you have an index on the rows (or add one with a Record ID tool) you can rejoin data as necessary after doing your calculations.

Iain

[jeongilyoon]

Thank you very much.
DOUBLE TYPE Is there an option that can ask for automatic total?

Previously FORMULA [Field_1] + [Field_2] + [Field_3] ........ [Field_15] We have calculated the total in this way. Is there a simpler way?

[haroon_sa]

@jeongilyoon

you can use "sum" option in summarize tool,it will give total sum.hope this will helps you.

if any queries let me know...

[jeongilyoon]

Thank you very much.

Field_1   Field_2   Field_3  Field_4   Field_5   Field_6

    1            1              1            1            1           1      

    1            1              1            1            1           1    

    1            1              1            1            1           1    

    1            1              1            1            1           1    

There are many records as many columns as shown.
Conventionally, we added the field by [Field_1] + [Field_2] + [Field_3] ... + [Field_6] with formula option and issued all the sum with summarize option.
My question is whether to make a table like the figure more easily sum up.

I am sorry that content transmission was not performed normally when used for translation.

[BenMoss]

I think I understand.

First of all, create a record ID field let’s call this ‘recordID’. Then we will use a dynamic formula too select fields that are double, or if the name is recordID, something like...

[Name] = recordID
OR
[Type] = double

The next step is what the previous posts have been missing. Use the transpose tool. Your key field will be the recordID field, whilst all others willl be data fields.

Then you can use a summerize tool, grouping by the recordID and summing the one value column to give you the total for each row.

You can then join this back to your original table if you wish.

Ben

[BenMoss · Accepted solution]

I've built out an example workflow with the mentioned logic.

Ben

[jeongilyoon]

thank you very much
It helped a lot. :D