Overview

SAS Visual Analytics might display "An error occurred" when you add an aggregated measure that uses Boolean operator to an object such as a list table. Typically, the problem occurs for these types of expressions: 

• The IF operator is used to compare a category.
• The IF operator is used to compare a date or a category combined with an AND.

Following are some examples.

The IF Operator Compares a Category

Here is the aggregated measure expression:

 

Here is the error displayed in a list table object:

The IF Operator Compares a Date or Category Combined with an AND

Here is the aggregated measure expression:

 

Here is the error displayed in a list table object:

 

 

Workaround

Create new numeric data items to replace the conditions that cause this issue.  For example:

1. Create a new measure and set it equal to 1 or 0.

2. Create a new aggregated measure using the Flag data item for the comparison.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Visual Analytics (on SAS Viya)	Microsoft® Windows® for x64	8.3.1		Viya
		Linux for x64	8.3.1		Viya
		Cloud Foundry	8.3.1		Viya
SAS System	SAS Visual Analytics	Microsoft® Windows® for x64	7.5		9.4 TS1M6
		Linux for x64	7.5		9.4 TS1M6

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

A fix for this issue for SAS Visual Analytics 7.51 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/I9T.html#64489

---

A fix for this issue for SAS Visual Analytics 7.5 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/F9L.html#64489

---

SAS Visual Analytics might display "An error occurred" when you add an aggregated measure that uses Boolean operator to an object such as a list table. Typically, the problem occurs for expressions use the IF operator to compare a category, or to compare a date or a category with an AND.

Type:	Problem Note
Priority:	high

Date Modified:	2019-07-22 14:42:36
Date Created:	2019-07-18 14:57:15