Product(s):	WaterGEMS, WaterCAD, HAMMER, SewerGEMS, StormCAD, SewerCAD, CivilStorm, PondPack
Version(s):	08.11.XX.XX and 10.00.XX.XX
Area:	Calculations

Problem

Can a user data extension with an IF, THEN, ELSE (iif) statement assign a value to another field?

For example, the statement below would result in the following error.

iif( [DerivedNodeResults_StructureDepth; Feet] >=10, [CircularStructureType_Diameter; Feet] =4, [CircularStructureType_Diameter; Feet] =3)

Error: "User Data Extension Problem: Error found in provided expression. Details: Incompatible returned data-type from this expression with respect to the one expected."

Solution

The "iif" statement can be used in a user data extension to report values. Then those values can be copied and pasted to the desired input field using a FlexTable.

For the example above, the following statement could be used.

iif( [DerivedNodeResults_StructureDepth; Feet] >=10, 4, 3)

Then those values could be selected in the element's FlexTable, copied, then pasted into another field.

Can a user data extension with an IF, THEN, ELSE (iif) statement assign a value to another field?

Problem

Solution

See Also