Num# shows wrong value-format

[beck_bakytbek]

Hi Folks,

I got a question:

i want to show the numbers as dimensions, like: 1000, 6000, 7000,

But my values do look like: 1000,00 and 6000,00, i've used the Num#()-function, but it does not work.

Does anybody have any idea?

Thanks a lot

Beck

[marcus_sommer]

If the numbers are fieldvalues floor(Field) should work. If it's the result of a calculation it needs to be wrapped with an aggr() like: aggr(floor(YourExpression), Dim1, Dim2).

- Marcus

[jonathandienst]

Num#() is an interpretation function, not a formatting function. Num#() produces the same format as the input data. You need the Num() function (no #). This is the formatting function. You can combine the fucntions like this

=Num(Num#(mynumber, '<incoming data format>'), '<desired output format>')

eg

=Num(Num#(mynumber, '0,00'), '0')

or

=Num(Num#(mynumber, '0,00'))

[beck_bakytbek]

Hi Jonathan,

i tried to implement your way of solution, but it does not work

[praveenkumar_ma]

Hi Beck,

Actual Num# syntax :

Num#(text[, format[, dec_sep [, thou_sep ] ] ])

Num syntax:

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

this might be helpful beck.

Thanks

PM