Datasets

[cl1818]

I am new to Alteryx. I have two input XLSX files. One file contains the rates in which the rates were updated each year, and the other has the data. I combined the 2 input excel file in one tab just to show how the calculations. But these are separated. I'm unsure how to create a formula from Excel that corresponds to Alteryx expressions. Thank you for your help.

[JoshuaM]

Hi @cl1818 , I am not aware of the formula Product() in Alteryx like excel. But the logic can be replicated to get to the same result. 

Using your rates table specifically FIXED_3, I got to the same result by implementing a multi row tool then a summarize tool. 

Since your new to Alteryx, think of the multi-row tool as a way to do operations using the previous, current, and next record for a column. This is where I use the logic below which multiples each row and just has a clause that if the previous row was Null (i.e. first record).

"IF IsNull([Row-1:FIXED_3]) THEN [FIXED_3]
ELSE
[FIXED_3]*[Row-1:Product]
ENDIF" 

Next the summarize tool can be used to select the last record. Just note that the data has to be structured so that each record is sequential for multiplication.

 

[apathetichell]

this is the same as using a formula tool to take the natural logs of each value (LOG[YOURFIELD]) ---- Summing the field 

in the summarize tool --- and then using exp([SUM_YOURLOGFIELD])

MATH --- IT'S CRAZY.