topic Re: Numeric Representation in straight table in App Development

Numeric Representation in straight table

dafnis14 — Sat, 26 May 2018 21:08:21 GMT

Hi,

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

Thanks!

petter — Sun, 27 May 2018 12:08:39 GMT

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 — Sun, 27 May 2018 13:07:00 GMT

Thanks, Peter.

Should life be so hard?..

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