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

 

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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
  • 777 views
  • 0 likes
  • 2 in conversation