Cell level calculations lin alteryx like excel

Question

I have to calculate the particular cell values by referencing to cells in different columns. For example - I have to fill the values in particular cell "R54"  in column R using the formula in excel =MIN(MAX(R48-$F$59*MAX(R49-R50,0),0),R45) in alteryx. F is another column in my data.Is it doable in Alteryx? Would appreciate any help on this.

KGT · Answer

Although possible, it's not advisable. This is not a good way to process it. Don't replicate the formula as a formula, replicate it by looking at what you are trying to do to the data, and performing those operations.

pstrasser · Answer

It is difficult to say for certain without example data and understanding if the data structure is set or dynamic, but as others have said, it is likely possible to set this formula up, but it may be a lot of work to do so. That being said, if you are just taking in the data from excel and excel is still your output, you can write excel formulas to your output via a string value that starts with an "=".

Otherwise, what I try to usually do is process my data from excel in such a way where all the data I need is in a single row by breaking up the original dataset calculating the values I need then joining it back together to do my calculation. This is similar to using "helper" columns in excel for formulas. If you still need help with this, it would be helpful to drop an example of the data you are working with.

Gaurav_Dhama_ · Answer

It is doable if there is a logic by which you are picking the values. If it is based of human judgement, then it will be tricky.

Even a consistent pattern can be good enough to get this value.