Excel column

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

Nouveau Microsoft Excel Worksheet (2).xlsx

Workflow

Developer

Developer Tools

Common Use Cases

Transformation

Dynamic Processing

Accepted answers

CharlieS

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.

20180828-EuroPrices.yxmd

mborriero

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.

All comments

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!

solution.yxmd

CharlieS

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.