Mapper Multiply Functoid Truncates Trailing Zeros (276820)

The information in this article applies to:

Microsoft BizTalk Server 2000

This article was previously published under Q276820

SYMPTOMS

The multiply functoid used in the BizTalk Mapper does not return trailing zeros after a decimal point. For example, if a map takes two input fields, quantity and price, and outputs to another field, extended price, if the extended price is 25.50, the data output is 25.5.

STATUS

This behavior is by design.

MORE INFORMATION

Trailing zeros can be added as output from the mapper by using a BizTalk Mapper scriptor functoid. The following scriptor functoid will format the output of a multiplication functoid to include two places to the right of the decimal place:

Function MyFunction1( p_strParm0 )
  MyFunction1 = formatnumber(p_strParm0,2)
End Function

Modification Type:	Major	Last Reviewed:	10/17/2003
Keywords:	kbbug kbpending KB276820