Welcome to the Oracle Analytics Community

Home› 3427576› Comments
Default Avatar
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

3427576 Rank 4 - Community Specialist

Comments

  • Hello Gianni, Thanks for your support. The issue got resolved by modifying the formula just like mentioned hereunder (1.0*("Fact - Purchasing - Invoice"."# of Non-Compliance POs")/("Fact - Purchasing - Invoice"."# of POs")*1.0)*100. As you suggested we used chart but not the pivot table as we need two measures to be…
    in Issue with Line-Bar Graph Comment by 3427576 Aug 31, 2017 4:03AM
  • Hello Gianni Thanks for your reply. Here are the formulas I used for the % columns (("Fact - Purchasing - Invoice"."Non-Compliance Spend")/ SUM("Fact - Purchasing - Invoice"."Non-Compliance Spend"))*100 (("Fact - Purchasing - Invoice"."Compliance Spend")/SUM("Fact - Purchasing - Invoice"."Compliance Spend"))*100
    in Issue with Line-Bar Graph Comment by 3427576 Aug 24, 2017 12:56PM