Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0811

...

  • Values with more than 20 digits after the Decimal point are truncated by this function.

  • Missing values for this function in the source data result in missing values in the output.
  • Multiple columns and wildcards are not supported.
  • Using a dash as a negative value indicator (e.g. '-###.00') in your formatting string can change values and their data types. For more information, see Supported Numeric Formatting. 

D s
snippetusage

Required?Data TypeExample Value
YesString (column reference), function, or Integer or Decimal literalMyPrice

...

Info

NOTE: You cannot create number format strings in which a 0 value appears before a # value. The following example strings are not supported: #.#0, #.#0#, #.#00

...

D s
snippetusage

Required?Data TypeExample Value
YesString'###.00'

...