</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <div id="ProjectTitle"></div> <div id="PageTitle"><div id="PageTitleText">Formatting Numeric Data</div></div> </div> <div id="AfterHeaderContent"> <!-- Spacing --> <span id="ToggleAllSectionsLink" class="FunctionLink"> <label id="CollapseAllLabel">Collapse All</label> <label id="ExpandAllLabel" style="display: none;">Expand All</label> </span> </div> <div class="BreadcrumbsContainer"><table><tr><td> <a href="WelcmPg.html">Welcome to LightSwitch Desktop Edition</a> > <a href="ComponentOneOLAPforLightSwitchOverview.html">OLAP for LightSwitch Overview</a> > <a href="OLAPforLightSwitchTaskBasedHelp.html">OLAP for LightSwitch Task-Based Help</a> > Formatting Numeric Data</td></tr></table></div> <div id="BodyContent"> <p>You can format numeric data as currency, as a percentage, and so on or create your own custom format.</p> <h3>To format numeric data at runtime:</h3> <ol> <li>Right-click a field in the Values area of the C1OlapPanel.</li> <li>Click Field Settings in the context menu. The Field Settings dialog box opens.</li> <li>Click the Format tab.</li> <li>Select one of the following options: <table style="BORDER-TOP-STYLE: hidden; HEIGHT: 150px; WIDTH: 100.89%; BORDER-BOTTOM-STYLE: hidden; BORDER-RIGHT-STYLE: hidden; BORDER-LEFT-STYLE: hidden" cellspacing="0" cellpadding="0" border="0"> <tbody> <tr> <td valign="top" width="77"> <p><b>Numeric</b></p> <p><b>Currency</b></p> <p><b>Percentage</b></p> <p><b>Scientific</b></p> <p><b>Custom</b></p> </td> <td style="BORDER-TOP-STYLE: hidden; BORDER-BOTTOM-STYLE: hidden; BORDER-RIGHT-STYLE: hidden; BORDER-LEFT-STYLE: hidden" valign="top" width="495"> <p>Formats the data as a number like this: 1,235. You can specify the number of decimal places and whether to use a 1000 separator (,).</p> <p>Formats the data as currency. You can specify the number of decimal places.</p> <p>Formats the data as a percentage. You can specify the number of decimal places.</p> <p>Formats the data in scientific notation. You can specify the number of decimal places.</p> <p>Enter your own custom format for the data.</p> </td> </tr> </tbody> </table> </li> <li>Click <b>OK</b> to close the <b>Field Setiings</b> dialog box. Notice how the values in the summary table change.</li> </ol> <a name="seealsobookmark"></a> </div> <div id="FooterContent"> <p> </p><p> </p><hr style="height: 1px"><p>Copyright (c) <script type="text/javascript"> var theDate=new Date() document.write(theDate.getFullYear()) </script> GrapeCity, inc. All rights reserved. <script> $(document).ready(function() { if (!(window.self !== window.top)) { // Not running in a frameset // Get the page name var pageName = location.href.substring(location.href.lastIndexOf("/") + 1); if (pageName.indexOf("#") != -1) { pageName = pageName.substring(0, pageName.indexOf("#")); } // Append to webframe.html var framePage = "webframe.html#" + pageName; location.href = framePage; } }); </script></p> <a href="http://our.componentone.com/groups/" target="_blank">Product Support Forum</a> | <a href="http://feedback.componentone.com/forums/255782-winforms-documentation" target="_blank">Documentation Feedback</a> </div> </body> </html>