Resolved: APDB Multilevel Crosstab Table Field Expression Invalid Syntax

Update 4/7/2026: 

The calculated field was broken after migration from stage to production. Removing the calculated field metric from the visualization and then re-adding it to the visualization resolved the error. The dashboard in production has been republished and is no longer producing the error.

APDB Multilevel Crosstab visualization resolving without error after updates.



GC0039781 - APDB Multilevel Cross Table Field Expression contains Invalid Syntax 

The APDB Multilevel Cross Table dashboard is giving me the error, "Your calculated field expression contains invalid syntax. Correct the syntax and try again."  I have the AY filter set to 2023, 2024, 2025.  I have the Term filter set to the Fall and Spring terms for those AYs.  See screenshot for metric and group breakdowns.  See screenshot for Show details pop-up.

Error message on APDB Multilevel Crosstab.

Error details: DISTINCTCOUNTOVER_INVALID_ARGUMENT.