Input Excel formulas

[DaisyJones]

Hi all,

Does anyone have any ideas on how we can input the excel formulas into Alteryx? I have a workbook which has a lot of formulas and I want Alteryx to bring in those formulas, not the value they produce.

Thank you

Daisy

[atcodedog05]

Hi @DaisyJones 

Excel formulas cant be directly be used in Alteryx

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

[binuacs]

@DaisyJones  https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Writing-Formulas-to-Excel/ta-p/1233...

[DaisyJones]

Thanks for this, but it's not quite what I was looking for

[DaisyJones]

So here is a crude example of what I mean

We have our Quantity and Unit cost and then we have two columns which create our Total Cost and our Profit. In Excel we type in the formula and the cell will populate the value of that formula. 

I want to bring in the data, but have the formula populated, not the value so something like this? Is this even possible?

 

Thank you

Daisy

[binuacs]

@DaisyJones Sorry I was thinking in the other way.