Old Forums
Search:
Technical support This forum is closed.
Version 1.x > Technical support > not rounding/truncating decimal numbers View modes: 
User avatar
Member
Member
nsightmedia - 1/16/2006 7:43:16 PM
   
not rounding/truncating decimal numbers
Hi all,

I have a need to save decimal numbers in the original number of decimal spaces, rather than truncating them. For example, I want to enter "4.1000" and not have the system truncate it to "4.1" . This should be easy. Help?

Thanks,

William.

User avatar
Member
Member
nsightmedia - 1/17/2006 12:40:33 AM
   
Re: not rounding/truncating decimal numbers
I can do this on the front end...so I am a newbie...thanks. No more posts until the problem is difficult.

Thanks,

William.

User avatar
Guest
admin - 1/17/2006 7:09:46 AM
   
Re: not rounding/truncating decimal numbers
Hi William,

I'm sorry for the delay in answering. As you wrote - this is rather a question of UI presentation as the number is stored in SQL Server without extra zeros. So you will need to use some number formatting function in your transformations.

Please let me know if you need any additional details.

Best Regards,

Top