Problem Note 62005: SAS® Visual Analytics might display "An element cannot be aggregated" when you create an aggregated measure
 |  |  |  |  |
When defining the expression for an aggregated measure, SAS Visual Analytics might display the following errors in the New Calculated Item dialog box:
Operand can only be aggregated, but this operator does not support aggregation.
An element cannot be aggregated.
This problem can occur when you try to use a character parameter with IF/THEN/ELSE operators.
In the following example, Parameter 2 is a character parameter:
This is how the expression appears in text:
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Analytics | Linux for x64 | 8.2 | 8.3 | Viya | Viya |
An update for this issue is available for SAS Viya 3.3. For instructions on how to access and apply software updates, see the Managing Your Software section of the SAS Viya 3.3 Administration document at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.3&softwareContextId=softwareUpdates
SAS Visual Analytics might not accept character parameters in the expression for an aggregated measure that uses conditional operators.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2018-06-06 09:20:40 |
| Date Created: | 2018-03-20 07:07:53 |