Multi-Row Formula according to Tile grouping

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

Help

Accepted answers

philipmannering

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

All comments

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

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

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235