community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Ratio

BRRLL99
11 - Bolide
‎02-15-2023 02:27 AM

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

 

Labels:
Reply
0 Likes
2 REPLIES 2
ShankerV
17 - Castor
‎02-15-2023 02:29 AM

 Hi @BRRLL99 

 

Use the formula tool.

 

ShankerV_1-1676457959744.png

Many thanks

Shanker V

Ratio.yxmd
Reply
0 Likes
ShankerV
17 - Castor
‎02-15-2023 02:36 AM

Hi @BRRLL99 

 

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

 

 

Many thanks

Shanker V

Reply
0 Likes
connect with mentors
designer new user guide
Labels
Top Solution Authors
View All