Multi-Row warning after second multi-row added?

brendafos

I have the typical spreadsheet which needs null values filled in from the above row.

There are two columns (next to each other) which I need to do copy down from above on.

The first column is type Double - and ID field:

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

I run this to a Browse and do NOT get any errors.

Then I add the next column fix - another Multi-Row:

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

When I run this I get an error about the first Multi-Row in the sequence about it resulting in a String... but it should remain a double.

Is this error really related to the first Multi-Row, or it the error on the second Multi-Row? 

Here's what I'm doing with the Select actions. But if I take it out I still get the error on the second Multi-Row.

Thanks for your help,

Brenda

jdunkerley79

Second screenshot looks like you have Visit ID selected instead of Disch Date.