Skip to Content
0
Former Member
Jan 29, 2007 at 02:49 PM

problem with decimals

25 Views

hello all,

I am having a field that has type p decimals 1. now i need to format this field in a specific manner.

if the value is 4.0 then i want to output 4 and if output is 5.6 then i want to output 5.6.

i was wondering how to achieve the formal. I tried "shift right" but dint work; One of the possible solution is checking the last digit and if it is 0 and then is preceded by point i need to delete both of the digits. any other solutions??

will wait for your expert input.

thanks and regards,

Gaurav.