I am a little confused when it comes to choosing between an Aggregated Measure and a Calculated Item, they seem to me to have the same functionality. Could someone provide an example of the difference and when to either option.
Hello,
A calculated item is evaluated at the row level whereas an aggregated measure is evaluated in an aggregated context.
Generally speaking, you can use a calculated item anywhere in VA you can use a normal data item (category, measure, or date).
Aggregated measures can be used only in a report object where the data is being aggregated. For example, you cannot display an aggregated measure in a list table that shows detail data.
There are certain types of expressions that can only be used in an aggregated measure, like the periodic operators used to calculate year-to-date.
Hopefully that clears things up a little bit. For the most part if you are not sure which one to use, then you probably want a calculated item.
Sam
Hello,
A calculated item is evaluated at the row level whereas an aggregated measure is evaluated in an aggregated context.
Generally speaking, you can use a calculated item anywhere in VA you can use a normal data item (category, measure, or date).
Aggregated measures can be used only in a report object where the data is being aggregated. For example, you cannot display an aggregated measure in a list table that shows detail data.
There are certain types of expressions that can only be used in an aggregated measure, like the periodic operators used to calculate year-to-date.
Hopefully that clears things up a little bit. For the most part if you are not sure which one to use, then you probably want a calculated item.
Sam
Great ! That clears it up, thank-you.
Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.
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.