thisRow = View.Last() does not respect sort order

Suggestion Box Bugs
3

Hi @Alexis_Hunt, welcome to the community.

The thing with sorting is that it’s only applied on output level but not the dataset level. When you’re referencing a table in a formula, the data set you’re receiving is always the one before sorting.

My preferred way to go about this would be:

  1. Add a column in your table for “Order” that would calculate like:
thisTable.Sort(false, Affliction).Sort(false, Stacks).Find(thisRow)
  1. Sort your view on that new Order column instead of explicitly specifying Stacks descending and Affliction descending (note that in the formula above the order of columns to sort on is reverse)
  2. In your disable if formula, have something like
thisRow.Order != thisTable.Order.Max()
1 Like