Num# of numbers

[beck_bakytbek]

Hi Folks,

my filed does look like:

Class

120,00

i am trying to format (from 120,00 to 120) it by using of function num#() but i dont achieve any expected results.

Does anybody have any idea?

Thanks a lot

[Akshesh_Patel]

hello,

something like this,

Num(number[, format[, dec_sep [, thou_sep]]])

Regards,

Akshesh

[beck_bakytbek]

Hi Akshesh,

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

[marcus_sommer]

Num#() is for converting a string into a number - it will return (if the recognition-pattern is set properly) the number with the default number-format (set per variable in the main-tab of the script). If you want to change the format you need to adjust this variable or to wrap the num#() with a num(). Important by adjusting the delimiter is that all parameter of num() are set.

Another way in your case might be just to use floor().

- Marcus

[beck_bakytbek]

Hi Marcus,

thanks a lot for your responce, i tried to implement it by using of Floor-function, as Floor(120,00), but it does not work

[marcus_sommer · Accepted solution]

For me it worked with:

num(num#('120,00', '###,##', ',', '.'), '#.##0')

floor(num#('120,00', '###,##', ',', '.'))

- Marcus

[beck_bakytbek]

Hi Marcus,

thanks a lot for your time and help, it does work great