ERROR: This calculation uses both aggregated and non-aggregated columns.

b_rad
b_rad Contributor
in Beast Mode

I have been using beast mode fields that used window functions and which validated and worked fine in my charts for years now.

However, today when I tried to add a new beast mode I am getting the following error

"This calculation uses both aggregated and non-aggregated columns. This may result in duplicate rows and unexpected behavior in charts. See this article for more information"

I read the article and it doesnt have any examples. Anyone has any idea on what changed?

Here is the example window function calculation that gives the above error.

SUM(SUM(CASE WHEN (Product Type = 'Custom') THEN ((QTY * Custom Price)) ELSE ((QTY * Regular Price))) END)) over (partition by Order Month)

Even a non-window aggregate function like the one below gives the same error.

CASE WHEN (Product Type = 'Custom') THEN (SUM(QTY * Custom Price)) ELSE (SUM(QTY * Regular Price)) END

Thanks in Advance

Tagged:

Best Answer

  • b_rad
    b_rad Contributor
    Answer ✓

    Update:

    False Alarm!!!

    This looks like a "warning" rather than a error. It still allows to create/save the beast mode calculation and works fine in the report.

    Sincere apologies for the trouble.

Answers

  • b_rad
    b_rad Contributor
    Answer ✓

    Update:

    False Alarm!!!

    This looks like a "warning" rather than a error. It still allows to create/save the beast mode calculation and works fine in the report.

    Sincere apologies for the trouble.

Categories