Using Your Own Excel Formulas in the Business Process

In Oracle Smart View for Office ad hoc analysis, you can create your own Excel formulas and members that calculate instantly without affecting other data. You can then open this Smart Form in your business process and execute the calculations that you created in Smart View.

For example, say you're analyzing business process data in Smart View, which is the Microsoft Office interface to your business process. You want to calculate the average profit margin for four products. You can add a row called "Average Profit Margin" to the grid, and then create a formula on the four rows listing the products' profit margins. Select the four rows. Then, in the new "Average Profit Margin" row, add the Excel formula =AVERAGE(D5:D8). The average profit margin is instantly displayed in the new row, but the new row is saved only in this Smart Form, and not the rest of the business process.

To make this customized ad hoc grid available in your business process, when you save it, select the option Save as a Smart Form. Then you can open and use this customized Smart Form, including the rows, columns, and calculations that you added, in your business process.

See Opening Forms.

You can even create a sandbox from a Smart Form (see Keeping Your Work Private with Sandboxes.

To learn more, see Oracle Smart View for Office User's Guide.

Videos

Your Goal	Watch This Video
Learn about calculating data using Smart Forms.	Adding Excel Formulas in Cloud EPM