Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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'))
Hi Jonathan,
i tried to implement your way of solution, but it does not work
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