Error code "CONTEXTUAL_NESTED_AGGREGATION"

Question & Answer
1

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

2

Hi,

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

1 Like
3

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

4

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