BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Jazzman
Obsidian | Level 7

Hello, I'm trying to make my VA report display the change of a rate from last year to this year in percentage points. The rate is a calculated element that is the sum of one column divided by the absolute frequency of the table. When I try to create a new calculated element that divides the rate by the rate of the parallel period I get the error "nested aggregate expressions are not supported. So what is the correct way of doing this in VA?

1 ACCEPTED SOLUTION

Accepted Solutions
PetriRoine
Pyrite | Level 9

Hello @Jazzman ,

 

Since nested aggregate expressions are not possible you could possibly work around this using aggregated data sources and then data joins. 

 

Best regards,

Petri

 

View solution in original post

1 REPLY 1
PetriRoine
Pyrite | Level 9

Hello @Jazzman ,

 

Since nested aggregate expressions are not possible you could possibly work around this using aggregated data sources and then data joins. 

 

Best regards,

Petri

 

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 352 views
  • 0 likes
  • 2 in conversation