[HELP] Applying formulas to different rows in Alteryx - Macro?

Hi team,

I've got a range of measures with each having a series of functions applied to the value of the measure. I was hoping to output the final calculation of each of the measure.

I've attached the sample data - column C shows the value of the different measures (column A) for different periods (unit is quarter). I've broken down the functions in different columns, and the final results I'm after is column G (I've embedded functions in column G applying the formulas to illustrate).

I've done this in excel, but I'm looking at a fairly large dataset with a lot more different functions / combinations of functions. Can this be done in one go in Alteryx? Would macros help?

Cheers,

sample data.xlsx

Developer

Input

Help

Interface Tools

Accepted answers

GrahamL

If the Dynamic Replace doesn't work for you then using a macro is fairly straightforward. You can leave the formula in the Excel sheet and then have the macro read and apply the formula. Take a look at the very simple example attached.

Let me know if this works for you.

Cheers

Macro Formula.zip

All comments

GrahamL

Hi there

Have you tried the Dynamic Replace tool? That allows you to edit the formula at run time. If not, you would need to write a formula macro to replace the expression of the formula.

Let me know how you go

Cheers

Anniefang

Thank Gilly!

Not sure how to write this macro? Do I need to write for each single formula?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703