Make the next 1 row true

Hi Community!

I have a quick problem, which I am sure there is an easy answer for but I am struggling to get my head around multi-row formulae.

The situation is, I have got one true value in a list of false values, and I would like to make the subsequent 1 record true also. Could anyone write me an expression to do this, or is there a simpler way to do this without the multi-row formula tool?

Thanks for your assistance in advance!

Andy

CURRENT FIELD VALUES	DESIRED FIELD VALUES
FALSE	FALSE
FALSE	FALSE
FALSE	FALSE
TRUE	TRUE
FALSE	TRUE
FALSE	FALSE
FALSE	FALSE

Developer

Expression

Accepted answers

New field: DESIRED VALUES

IF [Row-1:CURRENT FIELD VALUES] = "TRUE" THEN "TRUE"

ELSE CURRENT FIELD VALUES ENDIF

CHEERS,

All comments

New field: DESIRED VALUES

IF [Row-1:CURRENT FIELD VALUES] = "TRUE" THEN "TRUE"

ELSE CURRENT FIELD VALUES ENDIF

CHEERS,

I think Multi-Row is the only way to go here:

The formula will be something like:

If [CurrentField] = "FALSE" and [Row-1:CurrentField] = "TRUE" Then [NewField] = "TRUE" Else "False" Endif

Neil

I was getting myself in a right muddle with the row-2 values also!

Thanks so much!

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703