	Product(s):	APM Implementation and Performance Management
	Version(s):	all
	Environment:	N\A
	Area:	N/A
	Subarea:	N\A

Problem

Trying to use a date or enumerated type input in a calculated indicator's vb script and Test resluts show no errors, but live results in error:

...indicator could not be calculated because the value for the "" input was undefined.

Solution

The issue was that Asset Date attributes (and enumerated attributes) are stored in arrays in EXP (the EXP “Help” does not mention this).

Unfortunately, our testing revealed that our version (EXP 6.2.4) has a fault in which the calculation fails if Null values are encountered.

Dan tested the same script in Release 7, and he confirmed the software fault has been corrected in Release 7.

As a workaround in release previous to 7, have to “sweep” the database to find/eliminate all null input value attributes where possible.

Original Author:

Giselle Crawford