We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

format a number of type double with specific format

Comments

2 comments

  • Avatar
    Adrian Williams

    You can use the Format attribute within the OutputFields grid to format a string value. In this case the Format attribute would be set to  %,.2f   

    In this example that uses the Modify Fields node, the input 'Data' field (which is a double type) is converted to a string and is renamed to 'formattedValue'. The conversion includes the thousand separator and sets the precision to two digits

    See the node Help for further information on formatting.

    If you want to perform a similar conversion in the Transform node then the following example shows how to output a new field containing the formatted string:

     

    0
    Comment actions Permalink
  • Avatar
    Frankky

    thanks a lot!!

    0
    Comment actions Permalink

Please sign in to leave a comment.