Skip to Content
0
Former Member
Nov 02, 2012 at 12:27 AM

Sorting on column that uses the Last() function

33 Views

A column on my webi report uses the following formula.

=If (Last([Units1]) + Last([Units2]))>0 Then "Inactive" Else "Active"

My problem is that I cannot get this column to sort correctly.

Is it because of the Last() function ? I have tried using Max() instead but that gives incorrect totals.