Comparing value in current row to prior row in a Straight Table

[joshm43]

Good day -

I am trying to find a way to compare values between rows in a straight table (Chart)

For example:

Field Name: Company

Row 1)  Jones and Company

Row 2) Smith and Company

Row 3) Smith and Company

Row 4) Brown and Company

The expression would return a "True" for Row 3) - prior row has same value, but "False" for the other rows.

I have taken a look at both ABOVE() and FirstSortedValue(), but neither seems to have the desired result.

I would appreciate any suggestions.

[joshm43]

I have tried =IF(ABOVE(Company)=Company, 1, 0) and =IF(BELOW(Company)=Company, 1, 0) with no success.

[joshm43 · Accepted solution]

I continued testing and found that using the "TOTAL" qualifier in the expression resolved the issue with ABOVE().