Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Help for rule design to replace VLOOKUP

Kiran_Jun 4 2019 — edited Jun 7 2019

Hello everyone,

I am currently implementing EPBCS at a professional services firm to replace their existing Excel heavy solution. Given that I am new to EPBCS, I would like some help to design rules that are similar to VLOOKUPS in Excel. Here is an example:

FTE % (Driver input by users) * Average Office Level Hours (this would be the data I would need to retrieve via VLOOKUP) to get Standard Hours of an employee

How should I go about this?

Thanks in advance,
Kiran

Added on Jun 4 2019

#business-intelligence-applications, #help, #performance-management-applications, #planning-and-budgeting, #script

4 comments

997 views