Appendix : Legacy Presto components : Mashables and Mashups : Mashups in MashZone NextGen Wires : Creating Mashups in Wires : Add Actions or Other Blocks : Built-in Functions for Decorator, Mapper and Transformer Blocks : Currency Value
Currency Value
Converts a fully-formatted currency amount (a string) to a numeric value that can be used in calculations. This also supports currency values in exponential forms such as $1.6E8.
*If you have not already mapped a field to the Extract number from currency value property, enter a formatted currency amount or click to open the Path Selector and map a field.
*Select the symbol (Period separated fractions or Comma separated fractions) that is used as the decimal symbol in this currency field.
The result of this function always uses a period as the decimal symbol. No currency or thousand separator symbols are included in the result. Plus or negative signs are retained.
Copyright © 2013-2017 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback