Categories
- All Categories
- 90 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14.2K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 53 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations Gallery
- 2 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
What is the issue of below logic in FAW?
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.
Answers
-
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
1 -
Hello,
I'm unable to Change the aggregation method from Auto to SUM since not visible.
Please help me this.
Thanks,
0 -
Please Use the tabs in the Properties pane, select the measure and aggregation type.
0 -
I try the same way but unable to do it.
0