Search
  • The Performance Architects Team

Your Complete Guide to Data Entry Shortcuts in Oracle Planning and Budgeting Cloud Service (PBCS)

Data entry is a laborious and time-consuming activity, pervasive throughout virtually every company’s planning and budgeting cycles. Users entering data via simple forms in Oracle Planning and Budgeting Cloud Service (PBCS) can utilize the following shortcuts to save time during the data entry process. Simply enter one of the following commands in the desired data cell and press “Enter” on your keyboard. It is important to note that these commands are only available when accessing simple forms via web browser and are not supported in Smart View.

K Entering the “K” command in a data cell will take the preceding cell value and convert it into thousands. Example: “7K” = 7,000

M Entering the “M” command in a data cell will take the preceding cell value and convert it into millions. Example: “7M” = 7,000,000

“Add” or + Entering the “Add” or + command in a data cell will take the preceding cell value and add the number you enter to it. Example1: “100Add70” = 170 Example2: “100+70” = 170

“Sub” or ~ Entering the “Sub” or ~ command in a data cell will take the preceding cell value and subtract it by the number you enter. Example1: “100Sub10” = 90 Example2: “100~10” = 90

“Percent” or “per” Entering the “Percent” or “per” command in a data cell will take the preceding cell value and multiply it by the percentage you enter. Example1: “100Percent10” = 10 Example2: “100per10” = 10

“Increase” or “inc” Entering the “Increase” or “inc” command in a data cell will take the preceding cell value and increase it by the percentage you enter. Example1: “200Increase10” = 220 Example2: “200inc10” = 220

“Decrease” or “dec” Entering the “Decrease” or “dec” command in a data cell will take the preceding cell value and decrease it by the percentage you enter. Example1: “200Decrease10” = 180 Example2: “200dec10” = 180

“Power” or “pow” Entering the “Power” or “pow” command in a data cell will make the number you enter an exponent of the preceding cell value. Example1: “100Power2” = 10,000 Example2: “100pow2” = 10,000

“gr” Entering the “gr” command in a data cell will take the preceding cell value and grow it by the percentage you enter. Example: “200gr50” = 300

Have any other shortcuts that might benefit others in the PBCS community?  Please leave a comment below with your suggestions!

#oracle #OraclePlanningandBudgetingCloudServicePBCS #cloud #PBCS #shortcuts #SmartView

Computer%20with%20Graph_edited.jpg

BLOGS

© 2006 - 2020 by Performance Architects

  • Twitter
  • LinkedIn
  • YouTube