Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
if the , is a decimal seperator use: num(<fieldname>,'0')
Hi B_knuever,
thanks a lot for your responce, i treid it, but it does not work
Then I am guessing you are using decimal "." so num(replace(<fieldname>,',','.'),'0')
Hi Beck,
Use the function Floor() for this.
Jordy
Climber
Hi Jordy,
thanks a lot for responce and time, i try and will report, when i have any positive results
thanks a lot