Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

computing ratio with column values

hamzam
8 - Asteroid

hi,

 

this seems like a simple problem, but im unable to figure it out. basically I want to be able to compute the 2nd row / first row to give me a ratio -- in this e.g. 0 / 13084

 

acc.PNG

2 REPLIES 2
Emil_Kos
17 - Castor
17 - Castor

Hi @hamzam ,

 

I think you need to use muli row formula in order to do this.

You will have more than 2 lines in real data? 

 

 

ImadZidan
12 - Quasar

Hello @hamzam ,

 

This will give you an idea. @Emil_Kos  is right about the multirow tool.

 

I have a feeling it is not as simple as it looks. Please give the full scenario.

Labels