Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Ratio

BRRLL99
11 - Bolide

I have 2 outputs from summarize tool

 

data1 : 

count

100

 

data2:

sum

897

 

I would like to ratio count/sum 

Ratio should be shown in one row like excel

 

BRRLL99_0-1676456808800.png

 

2 REPLIES 2
ShankerV
17 - Castor

 Hi @BRRLL99 

 

Use the formula tool.

 

ShankerV_1-1676457959744.png

Many thanks

Shanker V

ShankerV
17 - Castor

Hi @BRRLL99 

 

In the above, please read both the inputs as from summarize tool of your issue.

 

 

Many thanks

Shanker V

Labels