Multi-Row Formula according to Tile grouping

[sahartz]

Hi All,

I have data per customer (1st column) and I want to check if there is a change in the Country per customer (check changes in column 'Newcountry_ChangeLog')

I used the 'Multi-Row Formula' tool, but the formula is checking also the next customer and I want to check per customer.

the formula I used -

and the results I got -

In actual the last line per customer should not show any change in the address, so the marked lines should be 'NoChange'

what I am doing wrong?

Thanks

Sahar

[PhilipMannering]

Try referencing the row above ([Row-1:Newcountry_ChangeLog]), rather than the row ahead. This should solve your issue.

[sahartz]

@PhilipMannering 

So I got the first row incorrect...

[PhilipMannering]

Sorry, I mean you should use Row-1 where you have used Row+1, so:

If [Newcountry_ChangeLog] != [Row-1:Newcountry_ChangeLog]
then 'Change'
else 'No Change'
endif

[sahartz]

PhilipMannering

thanks for all your help :) 

but same problem. Marked lines should show 'NoChange'

[PhilipMannering · Accepted solution]

Try changing Values for Rows that don't Exist to Closest Valid Row,