SYMPTOM:
Even after changing the VLDB property 'Display Null on Top' to place null values at the bottom, the null values are still present at the top.
STEPS TO REPRODUCE:
1. Create a report with an arbitrary attribute and metrics, some of which contains null values.
2. Change the VLDB property ‘Display Null on Top’ to display null values at the bottom of the report
3. Sort by the Revenue metric in ascending order.
4. The report displays that the null values are present at the top instead of at the bottom.
CAUSE:
One possible cause for this issue is that the Report Data Options property ‘Set the value to be used in place of empty values when the report data is sorted’ is enabled and the value of 0 is placed as a parameter. Hence, the null values are treated as 0 when sorting in ascending order, which causes them to be placed at the top.
ACTION:
Disable the option ‘Set the value to be used in place of empty values when the report data is sorted’, so the report will return the expected outcome as follows:
