SQL syntax error while running a multilevel pivot with SUM/AVG aggregate and conditions include tag and related list conditions - Known Error

SQL syntax error while running a multilevel pivot with SUM/AVG aggregate and conditions include tag and related list conditions Description In Tokyo, multilevel pivot reports fail to generate and due to no matching records found when using a filter that is filtering on Tag and a related list condition while aggregation is not 'Count' or 'Count Distinct'. A list report or a multilevel pivot report with aggregation set to 'Count' or 'Count Distinct' using the same filter will show the expected results.

Steps to Reproduce

1) On a Tokyo instance create a multilevel pivot report 2) Use a filter for Tag and a related list condition. For example, Tag has Risk and Time worked -> Task updated after Nov 1 - make sure you have records that met the conditions you set 3) Set aggregation to something other than 'Count' or 'Count Distinct'

Result: Report does not generate as it believes no matching records are found A list report or a multilevel pivot report with aggregation set to 'Count' or 'Count Distinct' using the same filter will show the expected results.

If you run the report then refresh the page, you will see SQL syntax errors appear

Workaround This problem is currently under review and targeted to be fixed in a future release. Subscribe to this Known Error article to receive notifications when more information will be available.