Solved: Referring previous row - Page 2

NIPUNAEKA89 · 10-02-2022 12:38 PM

Hi,

I need to show a text to the person who logged in 1st of each day. My logic is "last row's date is not equal to current row's date"

[_THISROW].[_ROWNUMBER]-1 <> Today()

But this doesn't work. Please help

dbaum

Your expression compares a row number to today's date. You need to use a function like SELECT or MAXROW to return the date from the row with the highest row number that is lower than the current row's row number, and then compare that date to today's date.

View solution in original post