Oracle Analytics and AI

User_J7TV2

 I'm using a simple logic in calculation, Please see the below..

C - NUMERATOR DIVERSE PROMOTIONS:

cast (FILTER ((COUNT(DISTINCT "HCM - Workforce Gains and Losses"."Basic Information"."Person Number")) using ("HCM - Workforce Gains and Losses"."Diversity"."Gender Code" <> 'M' or "HCM - Workforce Gains and Losses"."Ethnicity"."Ethnicity Code" <> '1') and ("HCM - Workforce Gains and Losses"."Diversity"."Gender Code" <> 'M' or "HCM - Workforce Gains and Losses"."Ethnicity"."Ethnicity Code" <> 'null') and ("HCM - Workforce Gains and Losses"."Ethnicity"."Ethnicity Code" <> '1' or "HCM - Workforce Gains and Losses"."Diversity"."Gender Code" <> '~NOVALUE~') and ("HCM - Workforce Gains and Losses"."Diversity"."Gender Code" <> '~null~') and ("HCM - Workforce Gains and Losses"."Business Unit"."Business Unit Name" in ('PTL US Corp','PTL US Field','PL US Corp','PL US Field')) and ("HCM - Workforce Gains and Losses"."Country"."Country Code"='US' ) ) as double)

C - DENOMINATOR DIVERSE PROMOTIONS:

COUNT(DISTINCT "HCM - Workforce Gains and Losses"."Basic Information"."Person Number")

C - DIVERSE PROMOTIONS:

cast (FILTER ((COUNT(DISTINCT "HCM - Workforce Gains and Losses"."Basic Information"."Person Number")) using ("HCM - Workforce Gains and Losses"."Diversity"."Gender Code" <> 'M' or "HCM - Workforce Gains and Losses"."Ethnicity"."Ethnicity Code" <> '1') and ("HCM - Workforce Gains and Losses"."Diversity"."Gender Code" <> 'M' or "HCM - Workforce Gains and Losses"."Ethnicity"."Ethnicity Code" <> 'null') and ("HCM - Workforce Gains and Losses"."Ethnicity"."Ethnicity Code" <> '1' or "HCM - Workforce Gains and Losses"."Diversity"."Gender Code" <> '~NOVALUE~') and ("HCM - Workforce Gains and Losses"."Diversity"."Gender Code" <> '~null~') and ("HCM - Workforce Gains and Losses"."Business Unit"."Business Unit Name" in ('PTL US Corp','PTL US Field','PL US Corp','PL US Field')) and ("HCM - Workforce Gains and Losses"."Country"."Country Code"='US' ) ) as double)/ COUNT(DISTINCT "HCM - Workforce Gains and Losses"."Basic Information"."Person Number")

Please help me for this issue.

Thanks.

Issue of logic in FAW.png

JohnW-Oracle

Hello,

It does not look like there is any problem with your logic but little tweeks may be required depending on the results. To troubleshoot this, include the calculated column with at least 1 fact and 1 measure from each Subject Area you use in the calculation in a Tabular (Table) Workbook. Change the aggregation method from Auto to SUM or whichever option you want to test with. Then provide the results to Support via an SR with an exported .dva file.

Regards,

John