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