Forum Discussion

Kurumi0418's avatar
Kurumi0418
Helper I
8 years ago

I Have one important question.

 

Hello everyone,

 

How to use value = table, question as blow :

 

Value:

Overall Turn rate history =
DIVIDE(
SUM('WAITING_TIME_REPORT_HISTORY'[Rule Output]),
SUM('WAITING_TIME_REPORT_HISTORY'[WIP])
)

 

Table:

C = DIVIDE(sum('WAITING_TIME_REPORT_HISTORY'[Rule Output]),sum('WAITING_TIME_REPORT_HISTORY'[WIP]))

 

BUT..............result is diff. so I want to know how could I set up in this question????

 

Need Help

8 Replies

  • quentin_vigne's avatar
    quentin_vigne
    Solution Sage
    8 years ago

    Hi Kurumi0418

     

    What result are you expecting ? Show us what the column C should look like (with value)

    You need a percentage ? 

     

    - Quentin

    • Kurumi0418's avatar
      Kurumi0418
      Helper I
      8 years ago

      Hi Quentin,

       

      I want "C_Table" = overall turn rate values, it doesn't percetage.

       

      Thanks.

       

      Because, I want use "C" to X bar, but now I just have overall turn rate value, and it doesn't same with "C"

       

      Overall turn rate is right valure = Rule output/WIP

       

      See the picture. thanks Quentin.

       

      • quentin_vigne's avatar
        quentin_vigne
        Solution Sage
        8 years ago

        Kurumi0418

         

        I'm note to understand what you want but did you try this : 

         

        CALCULATE(DIVIDE(sum('WAITING_TIME_REPORT_HISTORY'[Rule Output]),sum('WAITING_TIME_REPORT_HISTORY'[WIP]));ALL(WAITING_TIME_REPORT))

        If this doesn't work can you tell me the values expected of C_Table ? (Is C-Table the yellow line on the picture ? )

         

        - Quentin