right format of number

[beck_bakytbek]

Hi Folks,

i got the field with number like: 60000,0000. i tried to transform into like: 60000 but i dind't achive any results. i used the function: subfield and mid but it does not work.

Does anybody any idea how to resolve this issue?

Thanks a lot

Beck

[bramkn]

if the , is a decimal seperator use: num(<fieldname>,'0')

[beck_bakytbek]

Hi B_knuever,

thanks a lot for your responce, i treid it, but it does not work

[bramkn]

Then I am guessing you are using decimal "." so num(replace(<fieldname>,',','.'),'0')

[JordyWegman]

Hi Beck,

Use the function Floor() for this.

Jordy

Climber

[beck_bakytbek]

Hi Jordy,

thanks a lot for responce and time, i try and will report, when i have any positive results

thanks a lot