Oracle Analytics and AI

Hari S

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)

Shankar-Oracle

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