Replicating Excel Calculations with Functions in Oracle APEX
In part 3 of this series we are going to leverage functions to create calculations commonly performed in excel. Functions are programmatic in nature and provide a means for quering other tables, pulling in that data and then working with variables to really perform almost any formula provided in excel. The end result of a function is a single output, just like a cell in Excel. Our example today will begin by calculating OPS based off 2 virtual columns created in video 2 above. We will then showcase how you can call the function in a query. After that we will construct a slighlty more advanced function where we will calculate the team batting average, then compare to a players batting average and output the points above or below the team average the player is. Finally we will demonstrate how to create a view to hide the complexity of the virtual columns and functions for easy consumption and development inside Oracle APEX.
Sample Code:
https://github.com/chipbaber/apex_tex...
You may also want to view:
• Replicate an Excel Calculations inside an ...
• Replicating Excel Calculations with Virtua...
• Replicating Excel Calculations with Functi...
#oracle #apex #excel #calculation #oci #codeinnovate