If there is no row-1/+1

[df]

Hello,

I use the multirow-formular. I want to flag every Timestamp that has a other timestamp before or after with the (time)difference of 15 minutes.
now my probleme is that the first and the last row always gets flaged because there is no row-1 (for the first) and no row+1 (for the last).

How can i improve the formular that for the first timestamp only row+1 is used and for the last only row-1. Is this possible?

[LordNeilLord · Accepted solution]

Hey @df

You could add an extra contidion to your formula to say AND !IsNull([ROW+1:TimeStampDateTime])/AND !IsNull([ROW-1:TimeStampDateTime])

You will need to change your multirow formula to be NULL for Values that don't exist.

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome