Versions Compared

Old Version 1

changes.mady.by.user Elvis Kvalbergs

Saved on

compared with

New Version 2

changes.mady.by.user Gvido

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Returns the numbers contained in a string as a numeric value of appropriate type.

Syntax

 Val
Code Block
Val(String_Expression)

Arguments

String_Expression

String that contains a number to be converted to a numeric value.

Examples

Code Block
Val("9.56")

Above example will return 9.56. If the calculated member will have a formatting Integer then the display value will be 10.

Next example returns a numeric value from String Project Name that follows after -. So if the Project name is Demo-12, then the returned value will be 12.


Code Block
Val(


 ExtractString([Project (Job)].CurrentMember.Name,

 
 '.*-(\d+)', 1)


)

See also

Read more about ExtractString function that is used in the example.

Read here why it is suggested to use Val instead of StrToValue.