Format Cells (including column widths)



The Pennsylvania State UniversitySIMBA Hands-On Guide 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?PSU BI LaunchPad QA StepActionWe will start by making the Sponsored Program Name column wider.1.The Sponsored Program (IO/WBS) Name column value is right-clicked.?PSU BI LaunchPad QAStepAction2.The Format Cell...?option on context menu is clicked.?PSU BI LaunchPad QA StepActionWe 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.?PSU BI LaunchPad QAStepAction4.The OK button is clicked.?PSU BI LaunchPad QA StepActionThe column is now wide enough to display the values.?PSU BI LaunchPad QA StepActionNext, 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.?PSU BI LaunchPad QA StepActionIn 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.?PSU BI LaunchPad QA StepActionFirst, we will change the font.7.The Font dropdown is clicked.?PSU BI LaunchPad QAStepAction8.Times New Roman is clicked in the Font menu.?PSU BI LaunchPad QA StepActionNext, we will change the Font Size.9.The Font Size dropdown is clicked.?PSU BI LaunchPad QAStepAction10.12 is clicked on the dropdown menu.?PSU BI LaunchPad QA StepActionNext, 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.?PSU BI LaunchPad QAStepAction12.The B (Bold)?button is clicked.?PSU BI LaunchPad QAStepAction13.The I (Italic)?button is clicked.?PSU BI LaunchPad QAStepAction14.The U (Underline) button is clicked.?PSU BI LaunchPad QAStepAction15.The Font Color dropdown is clicked.?PSU BI LaunchPad QAStepAction16.The Sea Green option is clicked.?PSU BI LaunchPad QA StepActionYou 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.?PSU BI LaunchPad QAStepAction17.The $7000.00 value?in the Actual Revenue Column is clicked.?PSU BI LaunchPad QAStepAction18.The Numbers tab is clicked.?PSU BI LaunchPad QA StepActionFrom 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.?PSU BI LaunchPad QA StepActionNote the different options you have for formatting a number. In this case, we'll select Currency.20.The Currency button is clicked.?PSU BI LaunchPad QA StepActionThe 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.?PSU BI LaunchPad QA StepActionWe'd like to customize this option a bit, so we'll click the Custom button.22.The Custom button is clicked.?PSU BI LaunchPad QA StepActionWhen 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.?PSU BI LaunchPad QA StepActionWhen 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.?PSU BI LaunchPad QAStepAction26.The OK button is clicked.?PSU BI LaunchPad QA StepActionThe 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