Summary:
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.
Symptoms:
When a user runs a report, the Period End column brings in no data but drilling down shows correct data.
Causes:
Functions were put into the Period Aggregation tab of the Layout Editor instead of Filters tab.
Resolution:
Delete the function from the Period Aggregation tab and put it under the Filters tab. This should enable the data to be displayed.
Properties:
Cloud
Private Host 5.x