Oracle Fusion Data Intelligence

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

How to create a % column

Accepted answer
21
Views
1
Comments

Hello, I have a custom field which can assume 4 values, one for each of these columns:

I need to add a column where I show the percent of RETE column compared to the sum of each row. For instance at row 4 this percent should be 24/(47+0+24+0) = 34%.

I guess I need to create a new calculation but I have no idea how to start.

Any suggestion?

Thank you

Tagged:

Best Answer

  • Rank 5 - Community Champion
    Answer ✓

    I solved by creating a Key metric for each column and a Calculation for the percent calculation

Welcome!

It looks like you're new here. Sign in or register to get started.