How to remove trailing zeros

[varunreddy]

Hi All,

I have field A, which has values 1 & 0. We get data every month end. But for this month we got the values with trailing numbers (i.e. 1.00000000000000000000 and 0.000000000000000000).

Can anyone please help me in removing the trailing zeros?

Thanks in advance!

Cheers,

VK

[tresesco · Accepted solution]

Try like:

SubField(A, '.',1)  as  NewA

[sunny_talwar]

How about

Num(A, '##')

or

Num(A, '##.')

[Anil_Babu_Samineni]

May be this?

SubField(FieldName, '.', 1)

Or

FieldName * 1

Or

FieldName * Avg(1)

[varunreddy]

Hi Sunny,

Thanks for the response. But I don't see any value associated to that date. I see '-'.

[sunny_talwar]

I don't see any value associated to that date. I see '-'.

To what date?

[varunreddy]

As I mentioned, every month we get the data. The values will be 0 and 1. But for this month I got trailing zeros (i.e. 1.00000000000000000 and 0.00000000000000000).

When I created the list box for field "A", I see 0 and 1.

Now I selected the date 2/28/2017, then I see the association for the field A (i.e. 0 and 1 with White background in the list box).

Now I selected the date 3/30/2017, then I see no association for the field A (i.e. 0 and 1 with Grey background in the list box).

This is after using Num(A, '##').

[varunreddy]

Hi All,

Thanks for the quick response.

Cheers,

VK

[stigchel]

Maybe A is a string and /or your decimal separator is different and you need to use the Num# function? i.e.

num(num#( A, '#.#', '.' , ','),'##')