Forum Discussion

ScORE's avatar
ScORE
Icon for Helper I rankHelper I
8 years ago
Solved

Subtotal/total help needed for Custom Column assistance!

                I have a table with several columns.  One of the columns is labeled RIR.  It is a calculated column that i created to calculate a rate based on data that is located in other columns. ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    ScORE

     

    Hi, what happens if use a measure:

     

     

     

    RIR =
IFERROR (
    SUM ( '2017 Workbooks'[Total Rec Cases] )
        * DIVIDE ( 200000, SUM ( '2017 Workbooks'[Total Hours - Supervisory& Craft] ) ),
    0.00
)

    Let me know 

     

    Regards

     

    Victor

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
8 years ago

ScORE

 

Hi, what happens if use a measure:

 

 

 

RIR =
IFERROR (
    SUM ( '2017 Workbooks'[Total Rec Cases] )
        * DIVIDE ( 200000, SUM ( '2017 Workbooks'[Total Hours - Supervisory& Craft] ) ),
    0.00
)

Let me know 

 

Regards

 

Victor

  • ScORE's avatar
    ScORE
    Icon for Helper I rankHelper I
    8 years ago

    That worked!  THank you.  I tried that, but I was getting an werror because I was utting the sum in the wrong place!

     

    Thanks!