Datasets

Question

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.

Calculations.xlsx

apathetichell · Answer

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.

JoshuaM · Answer

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.

Product Calculation.yxzp