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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.