Conditional Formatting - SIMBA



The Pennsylvania State UniversitySIMBA Hands-On Guide TITLE \* MERGEFORMAT Conditional Formatting? 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.Conditional Formatting?Description:?Conditional Formatting changes the appearance of cells on the basis of specified conditions.Process Steps?PSU BI LaunchPad QA StepActionConditional formatting options can be found in the Analysis menu.?PSU BI LaunchPad QAStepAction1.The Analysis?tab in the Menu Bar is clicked.?PSU BI LaunchPad QAStepAction2.The New Rule button is clicked?in the?Conditional tab.?PSU BI LaunchPad QA StepActionThe Formatting Rule Editor provides all of the necessary settings to create conditional formatting. To start, we will select the object from the table that we will filter on. In this example, we will apply conditional formatting to the Grant ID column, based on the Business Area key field. For example, grant numbers in Business Area 3110 will display with a red font.3.The ... (ellipsis) button is clicked under Filtered Object or Cell.?PSU BI LaunchPad QA StepActionBecause we want to filter based on an object in the report, we will choose Select an object or variable.4.The Select an object or variable button is clicked.?PSU BI LaunchPad QA StepActionIn this example, we will navigate to the Business Area - Key field.5.The Business Area + button is clicked.?PSU BI LaunchPad QAStepAction6.The Business Area - Key button is clicked.?PSU BI LaunchPad QAStepAction7.The OK button is clicked.?PSU BI LaunchPad QA StepActionFor our condition, we want to look for the Business Area equal to 3110. If this condition is true, the font for the cell will be red.8.3110 is typed into the Operands field.?PSU BI LaunchPad QA StepActionWe want a second condition, so we use the Add button.9.The Add ... button is clicked.?PSU BI LaunchPad QA StepActionIn this case, we will again select the Business Area - Key object.10.The ... (ellipsis)?button is clicked under Filtered Object or Cell.?PSU BI LaunchPad QAStepAction11.The Select an object or variable button is clicked.?PSU BI LaunchPad QAStepAction12.The?Business Area + button is clicked.?PSU BI LaunchPad QAStepAction13.The Business Area - Key element is clicked.?PSU BI LaunchPad QAStepAction14.The OK button is clicked.?PSU BI LaunchPad QA StepActionFor our condition, we want to look for the Business Area equal to 5400. If this condition is true, the font for the cell will be green.15.5400 is entered into the Operands field.?PSU BI LaunchPad QA StepActionWe want a third condition, so we again use the Add button.16.The Add ... button is clicked.?PSU BI LaunchPad QA StepActionWe will again select Business Area - Key.17.The ... (ellipsis) button is clicked under Filtered Object or Cell.?PSU BI LaunchPad QAStepAction18.The Select an object or variable button is clicked.?PSU BI LaunchPad QAStepAction19.The Business Area + button is clicked.?PSU BI LaunchPad QAStepAction20.The Business Area - Key button is clicked.?PSU BI LaunchPad QAStepAction21.The OK button is clicked.?PSU BI LaunchPad QA StepActionFor our condition, we want to look for the Business Area equal to 3150. If this condition is true, the font for the cell will be blue.22.3150 is entered into the Operands field.?PSU BI LaunchPad QAStepAction23.The OK button is clicked.?PSU BI LaunchPad QA StepActionYou can see the color of the font has changed for the Grant ID depending on the Business Area.?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