Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Multi Field Formula Question

ltheiss99
6 - Meteoroid

Hi,

 

The excel sheet I am uploading has 100 columns that each need to be divided by it's respective column

 

The set up right now is columns 1-100 are the numerators and columns 101-200 are the denominators so the formula would be along the lines of:

 

field 1 / field 101 = new column A

field 2 / field 102 = new column B

field 3 / field 103 = new column C

etc.

 

I'm wondering if there is a better way to do it than manually entering all 100 formulas - maybe by utilizing the multi field formula?

 

Attached is an example of how my data is set up in Excel

 

Thanks,

Lauren

2 REPLIES 2
neilgallen
12 - Quasar
A more direct route would be to transpose the data and then either cross tab and sort it by type then create the ratio, or use a multi row formula to get the desired effect.

rafalolbert
ACE Emeritus
ACE Emeritus

Hi @ltheiss99,

 

Here you go:

 

img1.JPG

 

Thanks,

Rafal

 

#Excuse me, do you speak Alteryx?

Labels