ecx:forceNumber

The function ecx:forceNumber parses numbers in a string attribute as an actual number. This function works in tandem with exc:formatNumber.

Function Logic​

• If string_or_number is null:
  > return 0

• else if string_or_number is numeric:
  > return string_or_number

• else if string_or_number is convertible to numeric after replacing any , to . to ensure compatibility with different decimal separators:
  > return numeric converted value with . as decimal separator

• else if:
  > return 1

• end if

Examples

Structure​

ecx:formatNumber(ecx:forceNumber("user.AttributeType.StringAttribute"))