topic Re: Is there an option to calculate the automatic sum only for double type? in Alteryx Designer Desktop Discussions

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

jeongilyoon — Thu, 24 May 2018 04:58:43 GMT

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?

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

ivoller — Wed, 07 Mar 2018 04:23:04 GMT

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

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

jeongilyoon — Wed, 07 Mar 2018 04:41:09 GMT

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?

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

haroon_sa — Wed, 07 Mar 2018 05:51:43 GMT

@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...

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

jeongilyoon — Wed, 07 Mar 2018 06:28:04 GMT

Thank you very much.

Field_1 Field_2 Field_3 Field_4 Field_5 Field_6

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.

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

BenMoss — Wed, 07 Mar 2018 07:09:33 GMT

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

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

BenMoss — Wed, 07 Mar 2018 09:07:13 GMT

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

Ben

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

jeongilyoon — Wed, 07 Mar 2018 09:21:34 GMT

thank you very much
It helped a lot. :D