Fill Down then fix first null row above fill down.

Brain fried from death by PowerPoint day. I can't remember how to do this.

The field is [LN]. LN is a string.

I know how to fill down from 16 using the Multi-Tool and the following expression

if isnull([TEST_LN]) then [Row-1:TEST_LN] 
else [TEST_LN] 
endif

But this will leave the row above 16 still as [Null].

Without adding another Multi-Row Tool, how can I make this 15.

TEST_LN

[Null]

Help

Expression

Accepted answers

FrederikE

Hey @hellyars,

I see. That one should work for a string aswell.

if isnull([TEST_LN]) AND !IsNull([Row-1:TEST_LN])
then [Row-1:TEST_LN]
elseif isNull(TEST_LN)
THEN ToString(ToNumber([Row+1:TEST_LN])-1)
else [TEST_LN]
endif

All comments

FrederikE

Hey @hellyars,

I think this should do.

if isnull([TEST_LN]) AND !IsNull([Row-1:TEST_LN])

then [Row-1:TEST_LN]

Elseif isnull([TEST_LN])

then [Row+1:TEST_LN]-1
else [TEST_LN]
endif

hellyars

@FrederikE

Thanks, but that didn't really work. LN is a String. So it errors.

I tried to wrap the 4th line in toString(toNumber()) = No joy.

I tried converting LN to a number before the Multi-Role Tool and using your example = No Joy the first line is 0 instead of 15.

FrederikE

Hey @hellyars,

I see. That one should work for a string aswell.

if isnull([TEST_LN]) AND !IsNull([Row-1:TEST_LN])
then [Row-1:TEST_LN]
elseif isNull(TEST_LN)
THEN ToString(ToNumber([Row+1:TEST_LN])-1)
else [TEST_LN]
endif

hellyars

@FrederikE

Ah. I found the problem. I had Values for Rows that don't Exist set to 0 instead of NULL.

That fixed it and now your expression works. (second with the ToString(ToNumber())

THANKS.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703