Formatting number field (Decimal and Commas)

hii_amit

Hi,

how to hide the decimals and adding commas without compromising the decimal in overall total

Datatype used is Double

Input

1220.6

Output

1221

In output decimal of .6 should not lose its value while calculating the numbers as it might give big variance when we sum huge data.

Thanks

Help

Accepted answers

All comments

atcodedog05

Hi @hii_amit

Why dont you have 2 columns one in Int (rounded off) one in double (decimals)

Use Int for display. Use double for calculation filter it out later.

Or do the calculation before when field is double after calculation change it to Int(Round)

Just a thought😅 Hope this helps🙂

hii_amit

data is quite huge, hence cant create additional columns, moreover this is required in as excel output, hence don't think it will work. as we don't want to see decimals in excel but don't want to loose the value as well.

L_T

You might use the toString([Field1], 0, ",", "."), then Select Tool to convert the column to "double"

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703