MicroStrategy ONE

Display Null On Top

The Display Null on Top VLDB property determines where NULL values appear when you sort data. The default is to display the NULL values at the top of a list of values when sorting.

Wherever NULL values occur in a report, they appear as user-defined strings. NULL values result from a variety of scenarios. NULL values can come from data retrieved from the database, from cross-tabulation on a report, or from data aggregation on a report. You can specify the characters or strings that appear for NULL values. To do this, access the Project Configuration Editor, select the Report definition: Null values category, and type the strings you want to display in the appropriate fields.

Levels at Which You Can Set This

Project, report, and template