Oracle Fusion Data Intelligence

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

Exists condition in key metric

Received Response
21
Views
4
Comments

It it possible to add an exsists in custom metric?

Let's say I have col "A", "B", and "C".

image.png

In col "C" I want to count +1 when "A" >= 50 or when "B" = Y AND THERE IS NO OTHER VALUE IN "A" GREATER THAN 50.

Is it possible?

Answers