--- In [email protected], "Margaret Young" <[EMAIL PROTECTED]> 
wrote:
>
> In a map I am creating I need to label stores with their weekly 
> sales .  The sales field is an integer, example: 300000.  I need the 
> label to read "$300K"  What is the best way to do this?
> 
> Thanks,
> Margaret
>

Margaret,

Try creating a formula field for the label using the following syntax:

"$"+string(round([FIELD]/1000,0))+"K"

Where [FIELD] is the field name of sales.

Feel free to call if you have questions.

Michael Kesselman





------------------------ Yahoo! Groups Sponsor --------------------~--> 
Yahoo! Groups gets a make over. See the new email design.
http://us.click.yahoo.com/XISQkA/lOaOAA/yQLSAA/C5grlB/TM
--------------------------------------------------------------------~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/Maptitude/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Reply via email to