Hi,
I want to truncate a number in transformer of datatype
Decimal(18,9) to Decimal(10,6).
Thanks
Vinod
Truncating the number
Moderators: chulett, rschirm, roy
Re: Truncating the number
Try this conversionvinodhraj wrote:Hi,
I want to truncate a number in transformer of datatype
Decimal(18,9) to Decimal(10,6).
Thanks
Vinod
Left((Field(var1,".",1)),10):".":Left((Field(var1,".",2)),6)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: