In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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
Top Solution Authors