on 02-23-2011 4:53 AM
Hi
i have a simple mapping where i multiply a num with 1000.
and it working fine..but for 8.1 its going over the rane its showing 8100.005
what could be the problem for this?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
FormatNum function will take care your issues. Dont need to go for UDF.
formatNum is the standard way.
however if you want more precision you could write a UDF that uses a more detailed data type available in java
You can map the field like
multiply a num with 1000 >FormatNum (define accordingly)>Output
Thanks,
Hi,
it might be taking the float value . you can make use of Format Num..mapping function for this..
HTH
Rajesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.