Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I continued testing and found that using the "TOTAL" qualifier in the expression resolved the issue with ABOVE().
I have tried =IF(ABOVE(Company)=Company, 1, 0) and =IF(BELOW(Company)=Company, 1, 0) with no success.
I continued testing and found that using the "TOTAL" qualifier in the expression resolved the issue with ABOVE().