nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Keeping column data format after changing numeric to character

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

Accepted answers

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

Char(Round(:Missing Since, 0))

-Jeff

All comments

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

Char(Round(:Missing Since, 0))

-Jeff

Quick Links