Format Cells (including column widths)



The Pennsylvania State UniversitySIMBA Hands-On Guide Alternative Format TITLE \* MERGEFORMAT Format Cells (including column widths)? 2020 The Pennsylvania State University? Copyright 2020 Labyrinth Solutions, Inc. All rights reserved. Labyrinth Solutions, Inc., the LSI logo, and CampusOneTM are trademarks of Labyrinth Consulting, Inc. SAP, R/3, SAP NetWeaver, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries. Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects S.A. in the United States and in other countries. Business Objects is an SAP company.Format Cells (including column widths)?Description:In Webi, you can apply formatting to the values in your table or to the table itself.Process Steps?We will start by making the Sponsored Program Name column wider.1.?The Sponsored Program (IO/WBS) Name column value is right-clicked.2.?The Format Cell...?option on context menu is clicked.We can adjust the width to make sure the name is visible. In this case, we will use 2 inches.3.?2 is entered into the Width field.4.?The OK button is clicked.The column is now wide enough to display the values.Next, we will change the font and style of the values in the Business Area Key column.5.?The 3110 value in Business Area - Key column is clicked.In Webi, there are multiple ways to do the same thing! This time, we will use the Formatting menu from the top of the screen.6.?The Formatting tab in the menu bar is clicked.First, we will change the font.7.?The Font dropdown is clicked.8.?Times New Roman is clicked in the Font menu.Next, we will change the Font Size.9.?The Font Size dropdown is clicked.10.?12 is clicked on the dropdown menu.Next, we will use the Style menu to add bold, italic, underline, and color to the text.11.?The Style tab in the menu bar is clicked.12.?The B (Bold)?button is clicked.13.?The I (Italic)?button is clicked.14.?The U (Underline) button is clicked.15.?The Font Color dropdown is clicked.16.?The Sea Green option is clicked.You can see that our Business Area Key column is now bold, italic, underlined, and green. Next, let's look at the dollar amounts in the Actual Revenue column. There are a lot of options for formatting currency.17.?The $7000.00 value?in the Actual Revenue Column is clicked.18.?The Numbers tab is clicked.From the Formatting, Numbers tab, you can select one of the pre-defined formats from the dropdown, or you can click the Custom button for more options.19.?The Custom button is clicked.Note the different options you have for formatting a number. In this case, we'll select Currency.20.?The Currency button is clicked.The second option, with negatives displayed as red and with parenthesis, is close to what we want, so we'll select it.21.?The $1,234.57;?($1,234.57) format style is clicked.We'd like to customize this option a bit, so we'll click the Custom button.22.?The Custom button is clicked.When you customize the formatting, you have options to tell the report how to display when the value is zero or when the value is undefined. We'll use $0.00 when the value is zero.23.?'$'0.00 is typed into the Equal to Zero field.When the value is undefined, we'll also use $0.00.24.?'$'0.00 is typed into the Undefined field.25.?The Add?button is clicked.26.?The OK button is clicked.The Actual Revenue column is now formatted for currency.Disclaimer?Alternative Format Statement This publication is available in alternative media upon request.??Statement of Non-Discrimination The University is committed to equal access to programs, facilities, admission, and employment for all persons. It is the policy of the University to maintain an environment free of harassment and free of discrimination against any person because of age, race, color, ancestry, national origin, religion, creed, service in uniformed services (as defined in state and federal law), veteran status, sex, sexual orientation, marital or family status, pregnancy, pregnancy-related conditions, physical or mental disability, gender, perceived gender, gender identity, genetic information, or political ideas. Discriminatory conduct and harassment, as well as sexual misconduct and relationship violence, violates the dignity of individuals, impedes the realization of the University’s educational mission, and will not be tolerated. Direct all inquiries regarding the nondiscrimination policy to Affirmative Action Office, The Pennsylvania State University, 328 Boucke Building, University Park, PA 16802-5901; Email: aao@psu.edu; Tel: 814-863-0471. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download