Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi i have a field in table called Rate and its value are in decimal eg 19300.00 1 here i have a problem i have to do data massaging to remove the unwanted 1 which is present kindly help guys
left(Index(RATE,'.')-1)&mid(RATE,Index(RATE,'.'),3)
try to form this piece of code and got my problem solved
Hi,
Use Round( ) function
Like Round( YourColumn, 0.1 )
or you can also set the decimal place in the chart properties in the number tab select Expression -> Fixed to -> 2 Dicimal place.
Rgds
Anand
thnx but im loosing my data also there are not only this value i have many value is 1289.34 1..and different more
all i want to remove i that 1 after that value...
Hi Praveen,
You can use subfield function to truncate unwatned number,
Eg : num(SubField('19300.020 1',' ',1),'##0.0##')
Good Luck
Hi,
Try to make whole column in num like
num( Rate , '#,##0.##', '.' , ',' )
Rgds
Anand
Hi,
Do you share any sample file for that.
Rgds
Anand
i have used LEFT(RATE,8) and since i have gone through all the data and it contains all till 8 feilds only i have got what i want thnx guys this R&D would not have been possible without your help
left(Index(RATE,'.')-1)&mid(RATE,Index(RATE,'.'),3)
try to form this piece of code and got my problem solved
first collected the '.' position by using Index() then found the 2 values after dot and append with the value beofre '.'