[MultiRowFormula] How to create an unique key for using it on MultiRowFormula?

[Joker_Hazard]

Hello everyone!

I am struggling with trying to use multirow Formula and creating a unique key column to use in this tool.

Here's what I have:

We have an banking account column, a transaction column Called "Historical_description" and an ID column that refers to the number that specifies the transaction.

I need to create a validation process which creates an array (block) with each payment (TED receivable -> Balance Blocking -> Balance Unblocking). Those 3 steps exist FOR ONE payment only that is called "TED Receivable".

I tried to concatenate a few columns to create an unique key that could be used in the multirow tool, but no success... Do you guys have any clue or hints to give me? 

Thanks!

[apathetichell]

if isnull([Row-1:Historical_Description]) then 0 elseif([Historical_Description]="ted receivable" and [Row+1:Historical_Description]="balance blocking" and [Row+2:Historical_Description]="balance unblocking") then [Row-1:ted receivable]+1 else [Row-1:ted receivable] endif

will give each specific 3 record set an id

[apathetichell · Accepted solution]

change the multi-row formula to display two rows and then:

if isnull([Row-1:Historical_Description]) then 0 elseif([Historical_Description]="ted receivable" and [Row+1:Historical_Description]="balance blocking" and [Row+2:Historical_Description]="balance unblocking") then [Row-1:ted receivable]+1 else [Row-1:ted receivable] endif

[Joker_Hazard]

Hey apathetichell thanks for the reply.

I had an error with this formula!

[Joker_Hazard]

I was able to find the parsing error.

Thank u very much for the help!

[apathetichell]

Hi!

Could you try putting all three AND statements in an outer parenthesis - that makes a difference on my system.

[Joker_Hazard]

Exactly, thats what I did.. Once again, thanks for the help you provided!