An Element must be aggregated and cannot be used here

GrumpyEthel — Thu, 24 Apr 2025 09:16:55 GMT

Dear SAS Wiz,

Need help fixing the error i am facing , that An Element must be aggregated and cannot be used here....

I am facing an issue while attempting to , plesae see screenshot of the same error :

i am trying to get the Variance and subtracing previous quarter to current quarter and be able to add the visuals like adding an Arrow up if the difference is more and down if the difference goes negative ... the quarter 1 is configured as below:

Re: An Element must be aggregated and cannot be used here

arthurdpereira — Wed, 30 Jul 2025 18:26:09 GMT

Hi @GrumpyEthel,

Just change the option in Result type to Char.

Hope this solves it.

topic An Element must be aggregated and cannot be used here in SAS Viya

An Element must be aggregated and cannot be used here

Re: An Element must be aggregated and cannot be used here