When to Use a Fast Formula or Dynamic Column to Display Information in a Worksheet Column

You can vary worksheet column results using fast formulas and dynamic columns. The best method depends on the data you use, the complexity of the calculation, and how frequently you refresh worksheet data.

Data Used

Fast formulas can use any Oracle Fusion application data with a database item. Dynamic columns conditions can use other worksheet columns.

Calculations

Fast formulas can be anywhere from simple to complex with multiple compound conditions or multiple database records. Dynamic columns have simple if-then conditions or a few compound conditions.

Initializing and Refreshing Values

For both fast formulas and dynamic columns, the Start Workforce Compensation Cycle process sets the initial column values. The Refresh Workforce Compensation Data process re-evaluates column values every time it runs with one of these options selected:

• Refresh column defaults
• Full refresh

Dynamic column values are also re-evaluated if the refresh process runs with the Refresh dynamic columns option selected. And they're re-evaluated every time a manager leaves a column field if the dynamic column configuration has Change worksheet selected.

Configuration Process

You create formulas using the Fast Formulas task. You link them to worksheet columns using the Properties icon of the worksheet column. You build dynamic conditions using the Dynamic Columns icon of the worksheet column.