How do i group blank values last, and group other values low to high?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Is there a simple solution to grouping "Low to High" and placing the empty group at the end instead of the beginning of the report?

Photo of M

M

  • 80 Points 75 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Blake Harrison - DataBlender

Blake Harrison - DataBlender, Champion

  • 100 Points 100 badge 2x thumb
You can create a Formula Text field similar to this:

IF([Text Field]="","ZZ - Text Field is Empty",[Text Field])

You can then use this field as your Group by instead of the [Text Field] and it should show at the end if you're doing Low to High