topic Re: Aggregations Result to Wrong Sum Total. in SAS Visual Analytics

Aggregations Result to Wrong Sum Total.

maverickkub — Tue, 06 Sep 2016 05:58:09 GMT

Hi. I am working with a data set that poses me to create an aggregation which is correct when u drill down to a particular level but when the sum total is calculated for it the colum sub totals and totals are completely wrong.Is there a way to sum up plain aggregations? I m posting a screen shot of the issue that i am facing.Please Observe that the individual figures are fine but when you look at the subtotals and totals it yeilds absurd high totals.

Re: Aggregations Result to Wrong Sum Total.

BeverlyBrown — Wed, 21 Sep 2016 20:31:27 GMT

Hi @maverickkub, if you haven't already, please contact Technical Support, which is best equipped to diagnose what's happening. To see the ways to contact Tech Support, refer to: http://support.sas.com/techsup/contact/index.html Post back to this thread what worked for you!

Re: Aggregations Result to Wrong Sum Total.

Rightside13 — Wed, 07 Jun 2023 14:34:02 GMT

Hi maverickkub,

Did you ever get a solution to the below?

I have a similar issue where SAS is calculating the total rather than simply giving the total of the column.

Re: Aggregations Result to Wrong Sum Total.

acordes — Thu, 08 Jun 2023 17:56:42 GMT

This is no technical issue, welcome to aggregated measures.

I would need more information about the table behind.

What is the aggregation context, sum?

several rows of data are condensed in 1 line of the cross table?