Numeric Representation in straight table

[dafnis14]

Hi,

What is the way to define a numeric format for a dimension in a straight table?

Thanks!

[petter · Accepted solution]

Your dimension can be wrapped in a Num() function which allows for numeric formatting.

So if the expression for the dimension states:

Sales

Then

=Num(Sales,'0,00#','.',',')  Will format your number with , as thousands separator and period as decimal separator but with 0 decimals to display.

[dafnis14]

Thanks, Peter.

Should life be so hard?..

Wonder why the Sense table doesn't have the same feature as the straight table in QV...