It it possible to add an exsists in custom metric?
Let's say I have col "A", "B", and "C".
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?
Hi @Stefano_Mazzocca,
Can you please try using CASE Statement like following:
CASE WHEN (A > 50 AND B = 'Y') THEN (C + 1) ELSE C END
Hope this help.
Cheers,
Hi @Bhaskar Konar , unfortunately it doesn't help because current metric is:
CASE WHEN
(A >= 50 OR (A < 50 AND B = 'Y'))
THEN
(C + 1)
ELSE
C
END
This produces a +1 for both lines but I want +1 just for the second one since when there is a line with A >= 50 only that one should be counted. In fact the (A < 50 AND B = 'Y') condition should be used only when there is no other line with A >= 50
Can you please validate the requirement and my understanding.
Are you looking for something like below?
Hi @Bhaskar Konar , not really.
I must do the count for every person, my initial image was filtered by just a person for simplicity sake.
One person may have different rows and only one row for each person should have the +1:
Person1 is ok because there is only one row with A >= 50 and B is always N Person2 is ok because every A is < = 50 Person3 has an hybrid situation
Hi, I'm new to OTBI & FDI and need your help. Is it possible to do a report to identify missing default expense account in FDI or OTBI? Thanks for your help.
In FDI Payroll Costing subject area there is out of the box column for Transfer to GL Flag / Indicator, I've tried searching through tables in subject area to add physical column for transfer to GL Date but no luck. Does anyone know how I can populate a transfer to GL date in payroll costing? We are attempting to build a…
We made some changes in the Fusion UI, and those changes were reflected correctly in OTBI but not in FDI. To refresh the data in FDI, the Oracle support team advised me to reload the relevant functional area (Absence Management). I navigated to Application Administration → Human Capital Management, selected Absence…
Hi Team We are using SCM- Maintenance subject areas for reporting . We enabled the Asset related DFFs (CSE_ASSETS_B) under Data Configuration successfully but the Asset DFFs are not reflecting under Descriptive Flexfield Folder . We do not see any Asset folder even under the Descriptive Flexfield folder . Please advise if…
Data are synchronized with Oracle HCM and I can see PN 2470, which was terminated in the past. If I add any assignment information I find no records, why?
