I received this error code “CONTEXTUAL_NESTED_AGGREGATION” on the visual, any thoughts?

Calculations I used:
sum(actual)/sum({YTD Goal})
YTD Goal = target*0.07
actual and target are both from the data table

Thanks in advance


do you have calculated fields in your filters? They can cause this error, too.

1 Like

Hi @thomask, thanks for your quick response! I don’t have any filters applied on the visual

@Rachel1 Is this still an issue? It looks like correct syntax to me.