Val
Returns the numbers contained in a string as a numeric value of appropriate type.
Syntax
Val(String_Expression)
Arguments
String_Expression | String expression that contains a number to be converted to a numeric value. |
|---|
Examples
Val('9.56')
The above example will return 9.56. If the calculated member has the formatting Integer then the display value will be 10.
The next example returns a numeric value from String Issue Name that follows after -. So if the Issue name is Demo-12, then the returned value will be 12.
Val(
ExtractString(
[Issue].CurrentMember.Name,
'.*-(\d+)',
1
)
)
See also
Read more about ExtractString function that is used in the example.