Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Custom Formula in OTBI Analysis

Received Response
22
Views
1
Comments

I need to create a formula based on the below requirement in OTBI analysis. Please help how to achieve this by giving a sample snippet.

(Employees in G1 Grade & above with National as AE + Employees in G2 & Below with National AE)/ (All Employees in G1 & above with All Nationalities + Employee in G2 & Below National AE)

Tagged:

Answers

  • Shankar-Oracle
    Shankar-Oracle Rank 3 - Community Apprentice

    Try using CASE statement for each of the condition you need to code.