Need Assistance with Setting Up Multi-Row Formula Tool (never used it before)

[TomBock]

Hi:

I'm relatively new to using Alteryx.  Up until this point, I have not utilized the 'Multi-Row Formula' tool before.

Thus, I kindly request assistance with setting it up.  Attached are 3 files:

1. "SourceData -- Example Calculations":

1a. For [Amount], this demo files illustrates the subtraction of 2 rows (within the same column/field).   

1b. For now, the ABS value is fine.

1. "SourceData -- Example Calculations":

1c. For [Date1] and [Date2], I would like to identify the delta between Date1 and Date2 for each consecutive rows.  

2. "SourceData"

- Contains the data for [Amount], [Date1], [Date2] without the sample calculations...

- ... so, pls used this data source for the Alteryx process.

3. "Multi-Row Formula":

- I tried setting up the 2 different calculations using the Multi-Row formula tool.

My questions:

- How do they two multi-row formulas tools have to be modified in order to achieve the desired outcome?

[Clifford_Coon · Accepted solution]

Hi @TomBock ,

Here is a method:

 

 

The formulas are:

IF isnull([Row-1:Amount]) THEN null() ELSE ABS([Amount] - [Row-1:Amount]) ENDIF

and 

IF IsNull([Row+1:Date1]) THEN null() ELSE DateTimeDiff([Row+1:Date1],[Date2],"Seconds") ENDIF

Note: I did the time delta in seconds.

[TomBock]

@Clifford_Coon -- wow, that's PERFECT!!

Many thanks for your assistance w/ this question... I very much appreciate it.

Cheers,

Tom