Calculation Help

[AltExplore]

How do I perform the below calculation in Alteryx
SUM(A*B)/SUM(B)

Thanks

[afv2688]

Hello @AltExplore,

Here you go

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[AltExplore]

This works but I am not getting exact result in my scenario. Any thoughts while I try an replicate a sample

[afv2688]

Hello @AltExplore,

If you took directly my formulas it could be happending that the results were given as int values instead of double.

Try it with this workflow now.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[AltExplore]

I not only have columns A & B but other columns that need to be part of the final result.

These columns are a mix of dimensions and measures.

Please advise.

Thanks

[afv2688 · Accepted solution]

Hello @AltExplore,

I edited it and now it does a multiplication of all rows and divides it by the last one.

If you need anything else I would need a better clarification as with having only the other formula I cannot do much more)

Also the workflow you shared doesn't have any data. If you want me to work with your files please attach the data too.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[AltExplore]

I not only have columns A & B but other columns that need to be part of the final result.

A	B	C	D	E
231.5	574	Africa	New	12
64	687	Asia	Old	16
65	546	Pacific	ld	17
65	7465	Americas	ws	18
467	21	Africa	asr	20
32	2324	Australia	rzg	12

These columns are a mix of dimensions and measures.

Please advise.

Thanks

[afv2688]

Hello @AltExplore,

Here I give you three different ways to show the results.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[AltExplore]

I have more than 16 columns and append is failing. Need the record on same line and not in next line. How can this be resolved.

Also how to group the records based on an id

Thanks

[afv2688]

Hello @AltExplore,

you need to change the setting on the append tool:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards