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.