Numerics

[nareshthavidishetty]

Hi,

I have created  a table in that i am facing a problem below image is the reference.

How to convert this into numeric.

[Chanty4u]

=num(Num#(deviceid,'#.###,##',',','.'))

[ramasaisaksoft]

Hi Naresh ,

you said this a column in table

so i think u can convert this column /calculation into number

r.c on chart properties ->Number->number

[nareshthavidishetty]

Thanks to all for the great response.

I got resolved.

[Chanty4u]

grt...can u shre the expression which resolved ur issue?

and close the thread...it wil helps u others while searchng

[nagarjuna_kotha]

Hi Naresh,

Can you share your expression?

Regards,

Nagarjuna

[nagarjuna_kotha]

Hi Naresh ,

I will give one Suggestion to u.

See my attachment and In that see the difference If i use #,##0 and #,##.

Let me know worlking or not?

[nagarjuna_kotha]

For Example if you are using below Exp:

num(DeviceID,'#,##') as DeviceID .

Instead of Above ,Try like this >>. Num(DeviceID,'#,##0') as DeviceID

Regards,

Nagarjuna

[nareshthavidishetty]

Hi Nagarjuna,

It's not a calculated field.

[nareshthavidishetty]

I just wrote another load statement and then reload the same.Then its its working fine.