Format Rule if value in row below is greater than row above

fromr
Participant I

I am trying to get an up arrow in a simple weight tracker if weight is higher than before, as in, value in cell below in higher than value in cell above.

I am using format rules, I understand how to set the icon. I havenโ€™t been able to get the formula right. Would really appreciate some help with this!

Solved Solved
0 1 267
  • UX
1 ACCEPTED SOLUTION

Steve
Participant V

Try:

ISNOTBLANK(
  FILTER(
    "table",
    AND(
      (
        [_ROWNUMBER]
        = MAX(
          SELECT(
            table[_ROWNUMBER],
            ([_ROWNUMBER] < [_THISROW].[_ROWNUMBER])
          )
        )
      ),
      ([weight] < [_THISROW].[weight])
    )
  )
)

Replace table with the name of the table and weight with the name of the column you want to compare.

View solution in original post

1 REPLY 1

Steve
Participant V

Try:

ISNOTBLANK(
  FILTER(
    "table",
    AND(
      (
        [_ROWNUMBER]
        = MAX(
          SELECT(
            table[_ROWNUMBER],
            ([_ROWNUMBER] < [_THISROW].[_ROWNUMBER])
          )
        )
      ),
      ([weight] < [_THISROW].[weight])
    )
  )
)

Replace table with the name of the table and weight with the name of the column you want to compare.

Top Labels in this Space