Forum Discussion

jcoolen09's avatar
jcoolen09
Regular Visitor
2 years ago
Solved

Every row showing same value for custom column

I want to show a percentage for each row. The formula is their Billable Hours column DIVIDED by their Total Hours column. Why is it just showing the same value for every row? 

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  jcoolen09 ,

    I created some data:

     

    Here are the steps you can follow：

    1. Create measure.

    Measure =
var _sumbillable=
SUMX('MARSData',[Billable Hours])
var _sumtotal=
SUMX('MARSData',[Total Hours])
return
DIVIDE(
    _sumbillable,_sumtotal)

    2. Result:

     

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi  jcoolen09 ,

    I created some data:

     

    Here are the steps you can follow：

    1. Create measure.

    Measure =
var _sumbillable=
SUMX('MARSData',[Billable Hours])
var _sumtotal=
SUMX('MARSData',[Total Hours])
return
DIVIDE(
    _sumbillable,_sumtotal)

    2. Result:

     

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly