Developer's error

[#1]

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

[its_anandrjs]

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

[#3]

thnx but im loosing my data also there are not only this  value i have many value is 1289.34  1..and different more

[#4]

all i want to remove i that 1 after that value...

[#5]

Hi Praveen,

You can use subfield function to truncate unwatned number,

Eg : num(SubField('19300.020  1',' ',1),'##0.0##')

Good Luck

[its_anandrjs]

Hi,

Try to make whole column in num like

num( Rate , '#,##0.##', '.' , ',' )

Rgds

Anand

[its_anandrjs]

Hi,

Do you share any sample file for that.

Rgds

Anand

[#8]

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

[#9 · Accepted solution]

left(Index(RATE,'.')-1)&mid(RATE,Index(RATE,'.'),3)

try to form this piece of code and got my problem solved

[#10]

first collected the '.' position by using Index() then found the 2 values after dot and append with the value beofre '.'