Multi Field Formula issue

[wonka1234]

Hi,

I am trying to do multi field formula but I don't want to adjust the first row. It shouldn't be 0.

I want to update all the rows but the first one. Anyone know how I can do this?

[messi007]

@wonka1234,

You can create a new column with multirow formula :

Then you rename the new column :

Attached the workflow,

Regards

[IraWatt]

Hey @wonka1234,

I like to use this logic if your column doesn't contain NULLs:

Make the rows that dont exist eg. the row above the first row NULL from the dropdown. Then use a formula like this:

IF [Row-1:No of Days] = NULL() THEN 0 ELSEIF

This will trigger on the first row then you can apply all the logic for the next rows after it. If do have NULLs you can use a sample tool to take the first row.

[wonka1234]

Sorry , let me clarify, The first row should not be null or 0. it should be what is previously was.

See Im trying to update this column, everything below the first row.

[IraWatt]

Hey @wonka1234, what do you mean by the row previous to the first row ? If you mean the row after the first row then its [Row+1:Example]. The row previous to the first row can be  set to 0 or NULL. If you want to apply some specific logic to only the first row you can use the formula I suggested.

For instance:

IF [Row-1:No of Days] = NULL() THEN [No of Days] ELSE [Row-1:No of Days] ENDIF

[ChrisTX]

Add a RecordId tool, then with the Multi-Row tool use a formula like

If [RecordID] = 1 THEN [CLOSE BAL]

ELSE [Row-1:CLOSE BAL]

ENDIF

Chris