Excel column

[Youtecte]

hi everyone,

I really struggle to replicate those 3 excel columns on Alteryx (see the attached ), can someone please help me with this issue. I tried the multi-row formula but the result it's not the same. see the attached

Thanks

Youtecte

[danrh]

Try something like this in a Multi-Row Formula tool:

IF IsNull([Row-1:A]) THEN [A] ELSE [Row-1:C] ENDIF - [B]

See the attached.  Hope it helps!

[CharlieS · Accepted solution]

The first thing that was necessary was to format the input data in an appropriate numeric field format. Take a look at my attached solution and let me know if you have any questions.

[mborriero · Accepted solution]

Could you please provide some information about how do you create the column?

The column B has no calculation and it is not clear to me how to calculate it.

THanks,

Matteo.

[Philip]

Hi Youtecte

I don't understand the problem. Do you mean you have fields 1 & 2, and need to calculate field 3? What are the actual inputs?

[ponraj]

Here is the sample workflow for your case.  I created iterative macro to solve your case. 

Input 1Workflowmacro workflow