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 Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Help with formula that involves several steps of calculation

sspi1153
7 - Meteor

Hey there!

 

I have 3 rows of data. 

First one is time - let´s say I am interested in a 5 years time frame. 

Second and third are variables - X and Y

=> =>=> Data looks like =>=>=>

 Period      X         Y 

 1              0.9       1.1            

 2              0.5        1

 3              2           1.3

 4              4           0.3

 5              2.2        2.1

 

Calculation for the year one is prety simple.  Ijust need to summarize values  X*Y for all periods (1-5) =>(0,9*1.1)+(0.5*1)+(2*1.3)+(4*0,3)+(2.2*21).

 

Here comes the tricky part. 

 

In period 2 I want to skip value of X in period 1 and value of Y for period 5. Calculation should looks like => (0,5*1,1)+(2*1)+(4*1,3)+(2,2*0,3)

In period 3 I want to skip values of X for periods 1 and 2 and values of Y for periods 4 and 5. Calculation should looks like => (2*1.1)+(4*1)+(2*1,3)

 

Thanks and cheers!

 

 

 

1 REPLY 1
JohnJPS
15 - Aurora

HI @sspi1153,

 

For "period 2" and "period 3" you should be able to do multi-row formulas targeting "row-1" and "row-2" respectively, no?

 

Hope that helps!

John