BookmarkSubscribeRSS Feed
GrumpyEthel
Fluorite | Level 6

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 : 

GrumpyEthel_0-1745486086873.png

 

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:

 

GrumpyEthel_1-1745486167094.png

 

 

1 REPLY 1
arthurdpereira
Obsidian | Level 7

Hi @GrumpyEthel,

Just change the option in Result type to Char.

arthurdpereira_0-1753899907808.png

Hope this solves it.

SAS Job Execution Developer
I love sharing knowledge and helping the community.

Follow me:
GitHub | LinkedIn