topic Re: Formatting labels in Mapping Questions https://community.esri.com/t5/mapping-questions/formatting-labels/m-p/157947#M1763 <HTML><HEAD></HEAD><BODY><P>It is quite difficult to determine what you are trying to do? &nbsp;Maybe show the table with the required fields you wish to label and a sample formatted output you desire would help. &nbsp;Your field named [Layer] is misleading is this referring to a layer on your map? or referencing something else altogether?</P><P></P><P>So at first pass I am going on the assumption "<SPAN style="background-color: #ffffff;"> I want it displayed as currency and rounded."</SPAN></P><P></P><PRE class="language-javascript line-numbers"><CODE><SPAN class="token function">FormatNumber</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>Cost<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp; <SPAN class="operator token">&lt;</SPAN><SPAN class="operator token">--</SPAN> Will round to two decimal places<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><P></P><P style="color: #242729; border: 0px; margin: 0px 0px 1em;"><EM><STRONG>FormatNumber(number [,DecimalPlaces [,IncludeLeadingZero [,UseParenthesis [, GroupDigits]]]] )</STRONG></EM><BR /><EM><STRONG>or</STRONG></EM><BR /><EM><STRONG>FormatCurrency(Expression[,NumDigAfterDec[,IncLeadingDig[,UseParForNegNum[,GroupDig]]]])</STRONG></EM></P><P style="color: #242729; border: 0px; margin: 0px 0px 1em;"><EM>number : The number to format.</EM><BR /><EM>DecimalPlaces : Number of digits to display after the decimal point.</EM><BR /><EM>IncludeLeadingZero : Include a leading zero for numbers &lt;1 and &gt; -1</EM><BR /><EM>UseParenthesis : Show negative numbers in Parentheis (500) = -500</EM><BR /><EM>GroupDigits : Group large numbers with commas (or the regional delimiter)</EM></P><P></P><P></P><P><IMG alt="" class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/344474_FormatNumber.png" style="width: 620px; height: 439px;" /></P><P></P><P></P><P></P><P></P><P></P><P></P></BODY></HTML> Tue, 28 Mar 2017 14:49:11 GMT TedKowal 2017-03-28T14:49:11Z Formatting labels https://community.esri.com/t5/mapping-questions/formatting-labels/m-p/157946#M1762 <HTML><HEAD></HEAD><BODY><P>Not knowledgeable with coding, but I am trying to format labels for this one layer. I want 2 attributes labeled and have currently achieved, but for one of them I want it displayed as currency and rounded. I have found how to do each of these, however I'm a little confused how to implement both at the same time.</P><P></P><P>I am keeping in mind consistency of what I use (Python vs VBScript vs JScript) and am so far using VBScript for both, but</P><P></P><P>FormatPercent &amp; Round ([LAYER], 1)</P><P></P><P>does not work, and neither does removing the ampersand (and second space), nor putting the layer and 'Round' in an inner set of parentheses or anything.</P><P></P><P>Does anyone know of resources for how to apply multiple formats to the same layer? I found an example in our own data but it was for the text in particular (italics, bold, font size, color), using tags similar to (but NOT identical) HTML, however this of course is different.</P></BODY></HTML> Mon, 27 Mar 2017 15:31:10 GMT https://community.esri.com/t5/mapping-questions/formatting-labels/m-p/157946#M1762 meganbarron 2017-03-27T15:31:10Z Re: Formatting labels https://community.esri.com/t5/mapping-questions/formatting-labels/m-p/157947#M1763 <HTML><HEAD></HEAD><BODY><P>It is quite difficult to determine what you are trying to do? &nbsp;Maybe show the table with the required fields you wish to label and a sample formatted output you desire would help. &nbsp;Your field named [Layer] is misleading is this referring to a layer on your map? or referencing something else altogether?</P><P></P><P>So at first pass I am going on the assumption "<SPAN style="background-color: #ffffff;"> I want it displayed as currency and rounded."</SPAN></P><P></P><PRE class="language-javascript line-numbers"><CODE><SPAN class="token function">FormatNumber</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>Cost<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp; <SPAN class="operator token">&lt;</SPAN><SPAN class="operator token">--</SPAN> Will round to two decimal places<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><P></P><P style="color: #242729; border: 0px; margin: 0px 0px 1em;"><EM><STRONG>FormatNumber(number [,DecimalPlaces [,IncludeLeadingZero [,UseParenthesis [, GroupDigits]]]] )</STRONG></EM><BR /><EM><STRONG>or</STRONG></EM><BR /><EM><STRONG>FormatCurrency(Expression[,NumDigAfterDec[,IncLeadingDig[,UseParForNegNum[,GroupDig]]]])</STRONG></EM></P><P style="color: #242729; border: 0px; margin: 0px 0px 1em;"><EM>number : The number to format.</EM><BR /><EM>DecimalPlaces : Number of digits to display after the decimal point.</EM><BR /><EM>IncludeLeadingZero : Include a leading zero for numbers &lt;1 and &gt; -1</EM><BR /><EM>UseParenthesis : Show negative numbers in Parentheis (500) = -500</EM><BR /><EM>GroupDigits : Group large numbers with commas (or the regional delimiter)</EM></P><P></P><P></P><P><IMG alt="" class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/344474_FormatNumber.png" style="width: 620px; height: 439px;" /></P><P></P><P></P><P></P><P></P><P></P><P></P></BODY></HTML> Tue, 28 Mar 2017 14:49:11 GMT https://community.esri.com/t5/mapping-questions/formatting-labels/m-p/157947#M1763 TedKowal 2017-03-28T14:49:11Z