Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

MULTI FIELD FORMULA

Guglielmo91
6 - Meteoroid

Hello there,

 

i need some help to solve this matrix:

 

Guglielmo91_0-1636109284400.png

 

i need to fill the cells in the following way (excel language):

 

B2 =B1*A2

C2=C1*A2

D2=D1*A2

.

.

.

 

THEN 

B3 =B1*A3

C3=C1*A3

D3=D1*A3

 

and so on in order to fill the entire matrix. I guess i need to use the multifield formula, but i dont know how..

 

many thanks for your help 

2 REPLIES 2
Christina_H
14 - Magnetar

You can't actually do this in a multi-field formula since you are also referencing values from a previous row.  Here's an option transposing the data so you can complete all calculations in a single column.

Christina_Hurrell_0-1636112937033.png

 

PhilipMannering
16 - Nebula
16 - Nebula

This might also do the trick,

PhilipMannering_0-1636115152066.png

 

Labels