Number to String in a formula field

Question

I am using a formula field to concatonate 2 decimal values separated by a dash. However, I want the result to trim all unneccesary trailing zeros and decimal points for both values.

For example, I want values 10 and 8.5 to be "10 - 8.5". Now it shows "10.00 - 8.50".

The formula I am using is CSTR({field1}) + " - " + CSTR({field2}).

score 34 · Accepted Answer · edited Jan 12 '17 at 17:30

34

I believe this is what you're looking for:

Convert Decimal Numbers to Text showing only the non-zero decimals

Especially this line might be helpful:

StringVar text     :=  Totext ( {Your.NumberField} , 6 , ""  )  ;

The first parameter is the decimal to be converted, the second parameter is the number of decimal places and the third parameter is the separator for thousands/millions etc.

edited Jan 12 '17 at 17:30

mark_h

5,233
4
36
52

answered May 15 '09 at 16:58

Sam Trost

2,173
20
26

score 28 · Answer 2 · answered Apr 12 '12 at 18:05

28

CSTR({number_field}, 0, '')

The second placeholder is for decimals.

The last placeholder is for thousands separator.

answered Apr 12 '12 at 18:05

Paul Grimes

379
3
2

score 1 · Answer 3 · answered Jul 27 '12 at 13:30

i wrote a simple function for this:

Function (stringVar param)
(
    Local stringVar oneChar := '0';
    Local numberVar strLen := Length(param);
    Local numberVar index := strLen;

    oneChar = param[strLen];

    while index > 0 and oneChar = '0' do
    (
        oneChar := param[index];
        index := index - 1;
    );

    Left(param , index + 1);
)

Number to String in a formula field

3 Answers3

Linked