Subscribe Bookmark RSS Feed

Keeping column data format after changing numeric to character

saitcopuroglu

Community Trekker

Joined:

Sep 29, 2014

8800_2015-05-16_23-51-43.png

Hi all,

Does anybody know how to keep the char column as fixed dec as the num column?

Please check "Missing Since [In Days]" and the "Char Days" columns

Many thanks in advance

1 ACCEPTED SOLUTION

Accepted Solutions
Jeff_Perkinson

Community Manager

Joined:

Jun 23, 2011

Solution

You'll need to use the Round() function before converting with the Char() function.

    Char(Round(:Missing Since, 0))

-Jeff

-Jeff
1 REPLY
Jeff_Perkinson

Community Manager

Joined:

Jun 23, 2011

Solution

You'll need to use the Round() function before converting with the Char() function.

    Char(Round(:Missing Since, 0))

-Jeff

-Jeff