Setting decimal point in a script

[#1]

Hi,

We currently have the following script on the popup up label on our map. Showing correct data however, it isnt restricting the decimal points. So for example is showing:

0.89463795

1 Bloggs Avenue

1.57683045

....

Can you advise how in the script you can get it to fix to 2 decimals points. Here is current script:

[Distance (miles)] &'<br />'& [Address]&'<br />'& [Distance (miles)2]&'<br />'& [Distance (miles)3]&'<br />'& [Distance (miles)4]&'<br />'& [Distance (miles)5]&'<br />'& [Distance (miles)6]&'<br />'& [Distance (miles)7]

Cheers

Chris

[swuehl]

have you tried the num() function, like

num(Value, '#.00')

[#3]

Hi,

No we havent. Can you advise how that would be written in the script?

Cheers

Chris

[swuehl · Accepted solution]

Like

num([Distance (miles)],'#.00') &'<br />'& [Address]&'<br />'& num([Distance (miles)2],'#.00')&'<br />'& num([Distance (miles)3],'#.00')&'<br />'& num([Distance (miles)4],'#.00') &'<br />'& num([Distance (miles)5],'#.00')&'<br />'& num([Distance (miles)6],'#.00') &'<br />'& num([Distance (miles)7],'#.00')

[#5]

Hi Chris,

Hope, you can effort this

Use Num (number, format),

For Ex,

Num (Entity,’###########,##’) .

Regards,

Raja.

[#6]

Hi,

Thanks very much for this.

Lst question (and applies to all pop up boxes on maps) how do you put additonal text in them? So currently the pop up is as follows:

0.89

1 Bloggs Avenue

1.57

Love if we could get it to show as follows:

Location 1: 0.89 miles

1 Bloggs Avenue

Location 2: 1.57 miles

.....

Chris

[swuehl]

'Location 1: ' & num([Distance (miles)],'#.00') &' miles' &'<br />'&

[Address]& '<br />' &

'Location 2: ' & num([Distance (miles)2],'#.00') & ' miles' & '<br />' &

'Location 3: ' & num([Distance (miles)3],'#.00') & ' miles' & '<br />' &

'Location 4: ' & num([Distance (miles)4],'#.00') & ' miles' & '<br />' &

'Location 5: ' & num([Distance (miles)5],'#.00') & ' miles' & '<br />' &

'Location 6: ' & num([Distance (miles)6],'#.00') & ' miles' & '<br />' &

'Location 7: ' & num([Distance (miles)7],'#.00') & ' miles'