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
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.
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...
Try to make whole column in num like
num( Rate , '#,##0.##', '.' , ',' )
You can use subfield function to truncate unwatned number,
Eg : num(SubField('19300.020 1',' ',1),'##0.0##')
Do you share any sample file for that.
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
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 '.'
Retrieving data ...