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

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi ScORE

 

Have you considered using a calculated measure?

 

Something like 

 

Calc as Measure = SUM('2017 Workbooks'[Total Rec Cases]) * (200000 / SUM('2017 Workbooks'[Total Hours - Supervisory& Craft]))