How to get rid of some numbers in output

[sehgaln]

I need some help! in the table below, I have two columns (1 and 2). I only want the -1967.83 to show in the table and I want the rest of the numbers to be 0. 

How do I achieve that? Thanks!

Column dkfjdljflkdjfld (1)	Column hdlfjdljfdljfljdfld (2)
0	0
2.18E-11	2.18E-11
8.98E-12	8.98E-12
-1967.83	-1967.83
-3.64E-12	-3.64E-12
0	0
0	0
0	0
0	0
0	0
0	0
2.33E-10	2.33E-10
0	0
0	0
0	0
0	0
0	0
0	0
0	0

[Kenda]

Hey @sehgaln!

I would suggest using a Multi-Field Formula tool. Select both of your field names then use this expression:

iif([_CurrentField_]=-1967.83,[_CurrentField_],0)

Hope this helps!

[tlarsen7572 · Accepted solution]

Add a formula tool with the following function:

Round([1], .01)

[CharlieS]

Round to the nearest whole number using the following formula:

round([Column dkfjdljflkdjfld (1)],1)