Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

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