This article troubleshoots an issue where a Period End column returns no data due to the designer of the report conflating the Aggregation and Filters tabs.
When a user runs a report, the Period End column brings in no data but drilling down shows correct data.
Functions were put into the Period Aggregation tab of the Layout Editor instead of Filters tab.
Delete the function from the Period Aggregation tab and put it under the Filters tab. This should enable the data to be displayed.
Private Host 5.x