advanced label rounding in 10.2?

ChrisJ

well, advanced to me anyway....thanks all for giving this a shot:

I have big dollar values in my data which will appear in the labels; some will be in the hundreds of thousands, some will be in the millions.  I've been asked to label then with suffixes depending on their amount:

$945728.73 should appear as $946M (in the hundreds of thousands)

$1726538.34 should appear as $1.7MM (in the millions)

I'm ok with simple vb label rounding, ie. round(value,2), easy, but I'm way out of my depth with this new one, can anyone guide me?

thanks!

cj

RichardFairhurst

This should work as an Advanced Label expression using VB Script if you change the [Amount] field to your actual field name:

Function FindLabel ( [Amount]  )    if [Amount] >= 1000000 Then      FindLabel = "$" & Round( [Amount]/1000000, 1) & "MM"    Else      FindLabel = "$" & Round( [Amount]/1000, 0) & "M"    End If  End Functio

I don't know what country you are in, but In America the suffixes would be M and K for millions and thousands.(Repeated in your duplicate post.)

The field name should be added to the expression from the field list to ensure the excel spreadsheet table prefix is added to the beginning of the field name properly.